Advanced Features & Interactivity — Professional Dashboards

Power BI ka asli power interactivity mein hai — Slicers, Drill-through, Bookmarks, Custom Tooltips, Conditional Formatting, Hierarchies, Sync Slicers aur Row Level Security. Yeh features ek basic report ko professional interactive dashboard mein transform karte hain. Final part — Data Insights Power BI Masterclass complete! 🎉

📑 Is Final Part Mein Aap Kya Sikhenge:

Dashboard ko interactive aur professional banane wale 8 advanced features — har ek deep theory + practical guide ke saath:

• Slicers: Types (List, Dropdown, Between, Relative Date) — best use cases
• Drill-through vs Drill-down: Navigation patterns — kab kya use karein
• Bookmarks & Buttons: Page navigation, toggle views, show/hide panels
• Custom Tooltips: Hover par detailed insights — mini reports on hover
• Conditional Formatting: Data Bars, Color Scales, Icons, Rules — 5 types
• Hierarchies: Automatic vs Manual — drill-down structure
• Sync Slicers: Cross-page filter synchronization
• Row Level Security (RLS): Data access control — theory + implementation

🔍 Definition: Slicers are interactive filter controls placed on the report canvas that allow users to filter data across all visuals on a page by selecting values. Unlike the Filters Pane (which is hidden/collapsed), Slicers are visible and intuitive — users click on values to filter. Power BI supports multiple slicer types: List (checkboxes), Dropdown (compact list), Between (numeric/date range slider), Relative Date (dynamic — "Last 30 days"), Tile (button-style), and Chiclet (image tiles). Slicers are the primary user interaction mechanism in dashboards.

🎯 Samjho Hinglish Mein: Slicer ek filter button hai jo dashboard par dikhta hai — user click karta hai "North" — saare charts North ka data dikhane lagte hain. Dropdown mein compact rehta hai — space bachta hai. Between slider mein date range ya price range select karte hain. Relative Date mein "Last 7 days" ya "This Month" select karte hain — har baar open karne par automatically current date se calculate hota hai. Slicers dashboard ko interactive banate hain — bina slicers ke dashboard sirf ek static picture hai.

💡 Slicer Types — Complete Guide:
• List (Default): Checkboxes — multiple selections possible. Best for: Region, Category (3-10 items). Single Select mode bhi available hai.
• Dropdown: Compact — click to expand list. Best for: Space saving, many items (10+ products). Dashboard cleaner dikhta hai.
• Between (Range): Slider with min-max. Best for: Date range, Price range, Age range. Continuous numeric/date data ke liye.
• Relative Date: Dynamic — "Last 7 days", "This month", "Last quarter". Best for: Dashboards jo daily refresh hote hain — har baar automatically current period filter karta hai.
• Tile: Button-style chips. Best for: Compact selection, modern look. Few items (3-6).
• Image/Chiclet: Product images ya flag icons as slicer. Best for: Visual appeal, e-commerce dashboards.

📊 Slicer Types — When to Use:

💻 Slicer Configuration Tips:

// CREATE SLICER:
// 1. Click empty area
on canvas
// 2. Visualizations pane → Slicer icon
// 3. Drag column to "Field" well
// Example: Customers[Region] → creates Region slicer

// CHANGE SLICER TYPE:
// Select slicer → Format Pane → Slicer Settings →
// Style: Vertical List / Tile / Dropdown
// For Date column: Between / Before / After / Relative Date

// SINGLE SELECT MODE:
// Format → Selection → Single Select =
ON
// User can select ONLY one item at a time
// Useful
when chart needs single category context

// SELECT ALL OPTION:
// Format → Selection → "Select All" =
ON
// Adds "Select All" checkbox at top

// SEARCH BAR:
// Format → Slicer Header → Search =
ON
// Adds search box in slicer — essential for 20+ items

// RELATIVE DATE SLICER:
// Drag Calendar[Date] to slicer → change type to "Relative Date"
//
Set: "Last 30 Days" or "This Month" or "Last Quarter"
// Auto-updates daily — perfect for live dashboards!

⚠️ Common Mistakes:

• Mistake: 50 items ka List slicer — scroll karna padta hai, space waste. Fix: 10+ items ke liye Dropdown use karo — compact aur searchable.
• Mistake: Date slicer mein List type use karna — har date ek item ban jaata hai (365 items!). Fix: Date columns ke liye Between (range slider) ya Relative Date slicer use karo. List sirf categories ke liye.
• Mistake: Slicer interactions control nahi karna — ek slicer unwanted visuals ko bhi filter kar raha hai. Fix: Edit Interactions se control karo kaunsa slicer kaunse visual ko affect kare.
• Mistake: Bahut zyada slicers (8-10) — dashboard cluttered. Fix: Max 3-5 slicers ek page par. Zyada filters chahiye toh Filters Pane use karo ya separate filter page banao.

💬 Interview Questions:

🔍 Definition: Drill-down navigates within the SAME visual from a higher level to a lower level of a hierarchy — like Year → Quarter → Month → Day. It stays on the same page and same visual. Drill-through navigates to a DIFFERENT detail page while passing the context (filter) of the clicked item — like clicking "North" on a bar chart takes you to a separate "Region Details" page pre-filtered for North. Drill-down = deeper within same visual. Drill-through = different page with context.

🎯 Samjho Hinglish Mein: Drill-down = zoom in karna. Bar chart mein 2024 ka bar click karo → Q1, Q2, Q3, Q4 ke bars dikhte hain → Q1 click karo → Jan, Feb, Mar dikhta hai. Same chart, same page — sirf level deeper gaye. Drill-through = doosre page par jaana. Bar chart mein "North" region ka bar right-click karo → "Drill through to Region Details" → ek nayi page khulti hai jo sirf North ka detailed analysis dikhati hai — orders list, top products, customer details sab. Back button se wapas aa sakte ho.

💡 Key Differences:
• Drill-down: Same visual, same page. Hierarchy required (Year→Quarter→Month). Click arrows on visual header ya data point click. Goes deeper level by level. Back arrow to go up.
• Drill-through: Different page. Detail page with drill-through filter field. Right-click → Drill through. Passes selected value as filter. Back button auto-created. Used for detail exploration.
• When Drill-down: Time hierarchy explore karna hai. Category → Sub-category. Same visual mein deeper analysis.
• When Drill-through: Summary page se detail page jaana hai. Product click → product details page. Customer click → customer 360 page.

📊 Drill-down vs Drill-through — Comparison:

💻 Setup Guide:

// ═══════════════════════════════════════════
// DRILL-DOWN Setup:
// ═══════════════════════════════════════════
// 1. Create hierarchy in Fields Pane:
// Calendar[Year] → Calendar[Quarter] → Calendar[MonthName]
// 2. Drag hierarchy to visual's Axis
// 3. Visual header shows drill icons:
// ⬇ Drill down (one level)
// ⬆ Drill up (go back)
// ↕ Expand all (show all levels)
// ⊕ Go to next level (all items at next level)
// ═══════════════════════════════════════════
// DRILL-THROUGH Setup:
// ═══════════════════════════════════════════
// 1. Create a new page — name it "Product Details"
// 2.
On this page, add Drill-through filter:
// Visualizations → Drill through section →
// Drag Products[ProductName] here
// 3. Design detail visuals
on this page
// (Table with orders, KPIs, charts — all for one product)
// 4. Back button auto-appears (top-left corner)
//
// 5.
On SUMMARY page:
// Right-click
on any product bar/cell →
// "Drill through → Product Details"
// → Detail page opens filtered for THAT product!

⚠️ Common Mistakes:

• Mistake: Drill-down aur Drill-through confuse karna. Fix: Drill-down = same visual deeper. Drill-through = different page with context. Yaad rakho: "Down = deeper, Through = another page."
• Mistake: Drill-through page ka Back button delete karna. Fix: Back button essential hai — users ko wapas aane ka raasta chahiye. Delete mat karo — agar accidentally delete ho gaya toh Insert → Buttons → Back add karo.
• Mistake: Drill-through page ko visible rakhna — users confuse hote hain. Fix: Page tab right-click → Hide Page. Sirf drill-through action se accessible hoga.

💬 Interview Questions:

🔍 Definition: Bookmarks capture the current state of a report page — which visuals are visible/hidden, which filters are applied, slicer selections, and visual positions. Buttons are interactive elements that can trigger actions like navigating to a bookmark, page, URL, or going back. Together, Bookmarks + Buttons enable powerful scenarios: toggle between chart types (table ↔ chart view), create tab-style navigation (Overview / Sales / Products tabs), show/hide filter panels, and create presentation-style storytelling.

🎯 Samjho Hinglish Mein: Bookmark = screenshot + state save. Ek page par bar chart visible hai aur table hidden hai — yeh state bookmark karo "Chart View." Ab table visible karo aur chart hide karo — yeh state bookmark karo "Table View." Ab do buttons banao — "Show Chart" aur "Show Table" — har button apne bookmark se linked hai. User "Show Table" click kare toh table dikhe, "Show Chart" click kare toh chart dikhe. Ek page par do views — buttons se toggle! Same concept se tab navigation, filter panels, storytelling slides — sab ban sakta hai.

💡 Common Bookmark + Button Patterns:
• Toggle View: Chart View ↔ Table View — ek button se switch karo.
• Tab Navigation: "Overview", "Sales", "Products" buttons — ek page par tab-style navigation bina multiple pages ke.
• Filter Panel: Show/Hide filter panel — clean design, filters tab se open.
• Storytelling: Slide 1, Slide 2, Slide 3 — presentation mode bina PowerPoint ke.
• Reset Filters: "Clear All Filters" button — sab slicers reset.

💻 Toggle View — Step-by-Step:

// ═══════════════════════════════════════════
// TOGGLE VIEW: Chart ↔ Table
// ═══════════════════════════════════════════
// STEP 1: Create both visuals (chart + table)
on same page
// Position them overlapping (same location)

// STEP 2: Create "Chart View" bookmark
// → Show chart, Hide table
// → View tab → Bookmarks → Add Bookmark → Name: "Chart View"
// → Right-click bookmark →
Update
// → Bookmark settings: Data = OFF (don't save filters)

// STEP 3: Create "Table View" bookmark
// → Show table, Hide chart
// → Add Bookmark → Name: "Table View"

// STEP 4: Create toggle buttons
// →
Insert tab → Buttons → Blank (or icon buttons)
// → Button 1: Text = "📊 Chart View"
// Action = Bookmark → Select "Chart View"
// → Button 2: Text = "📋 Table View"
// Action = Bookmark → Select "Table View"

// STEP 5: Test in Reading View (Ctrl+Click in edit mode)

// HIDE/SHOW VISUALS:
// Selection Pane (View tab → Selection) →
// Click eye icon 👁 next to visual name to hide/show

💻 Tab Navigation Pattern:

// ═══════════════════════════════════════════ // TAB NAVIGATION (on single page) // ═══════════════════════════════════════════
// Create 3 groups of visuals
on same page:
//
Group 1: Overview visuals (KPIs, summary charts)
//
Group 2: Sales visuals (detailed sales charts)
//
Group 3: Products visuals (product analysis)

// Create 3 bookmarks:
// "Overview Tab" →
Group 1 visible,
Group 2+3 hidden
// "Sales Tab" →
Group 2 visible,
Group 1+3 hidden
// "Products Tab" →
Group 3 visible,
Group 1+2 hidden

// Create 3 buttons at top (tab bar style):
// [Overview] [Sales] [Products]
// Each linked to its bookmark

// Result: Looks like tabbed interface!
// Active tab button can be highlighted with different color

⚠️ Common Mistakes:

• Mistake: Bookmark mein Data = ON rakhna toggle views mein — slicer selections reset ho jaati hain. Fix: Toggle views ke liye bookmark mein Data = OFF karo. Sirf Display = ON.
• Mistake: Button ka Action enable nahi karna — click karne par kuch nahi hota. Fix: Button select karo → Format → Action → Toggle ON → Type = Bookmark → Select bookmark. Action ON karna mat bhoolo!
• Mistake: Bookmark update karna bhoolna after visual changes. Fix: Visuals change karne ke baad bookmark right-click → Update. Warna purana state save rehta hai.

💬 Interview Questions:

🔍 Definition: Custom Tooltips replace the default tooltip popup (which shows basic values) with a rich, designed report page that appears when users hover over a data point. Instead of just seeing "North: ₹5,20,000", you can show a mini-dashboard with KPI cards, small charts, images, and formatted text — all in a tooltip-sized popup. Custom Tooltips add depth to your dashboard without using extra space.

🎯 Samjho Hinglish Mein: Normal tooltip mein mouse hover karo bar par — ek basic popup dikhta hai: "Region: North, Sales: ₹5,20,000." Boring. Custom Tooltip mein hover karo — ek mini dashboard dikhai deta hai: Sales KPI card, YoY Growth %, Top 3 Products list, monthly trend sparkline — sab ek chhote popup mein! Space use nahi hota dashboard ka, lekin details available hain on-demand. Professional dashboards mein yeh bahut impressive feature hai.

💻 Custom Tooltip — Setup:

// ═══════════════════════════════════════════
// CUSTOM TOOLTIP — Step by Step
// ═══════════════════════════════════════════
// STEP 1: Create a new page
// Name it "Tooltip - Region"

// STEP 2:
Set page as Tooltip page
// Format Pane → Page Information →
// "Allow use as tooltip" =
ON

// STEP 3:
Set Tooltip page size
// Format → Canvas Settings → Type = "Tooltip"
// (Auto-resizes to tooltip dimensions — small page)

// STEP 4: Design mini visuals
on this small page
// → Card: [Total Sales]
// → Card: [YoY Growth %]
// → Small bar chart: Top 3 Products
// → Keep it compact — it's a tooltip!

// STEP 5: Hide this page (right-click → Hide Page)

// STEP 6: Assign tooltip to main visual
// → Select bar chart
on main page
// → Format → Tooltip → Type = "Report Page"
// → Page = "Tooltip - Region"

// DONE! Hover
on any bar → custom tooltip appears!

⚠️ Common Mistakes:

• Mistake: "Allow use as tooltip" ON karna bhoolna — tooltip assign nahi hota. Fix: Page Information mein toggle ON karo pehle.
• Mistake: Tooltip page par bahut visuals dalna — slow aur cluttered. Fix: Max 3-4 compact visuals. Cards + ek small chart = perfect.
• Mistake: Canvas size "Tooltip" set nahi karna — bada page as tooltip odd dikhta hai. Fix: Canvas Settings → Type = "Tooltip" set karo — correct dimensions auto-apply honge.

💬 Interview Questions:

🔍 Definition: Conditional Formatting dynamically changes the appearance of visual elements (cell background, font color, data bars, icons) based on data values. It makes patterns and outliers immediately visible. Power BI supports 5 types: Background Color (cell fill), Font Color (text color), Data Bars (in-cell bar charts), Icons (arrows, flags, traffic lights), and Web URL (clickable links). Available in Table, Matrix, and some chart visuals.

🎯 Samjho Hinglish Mein: Matrix mein 50 numbers hain — ek nazar mein kaunsa high hai, kaunsa low hai — pata nahi. Conditional Formatting lagao — high values green, low values red, medium yellow. Ab ek glance mein pattern clear hai! Data Bars lagao — har cell mein ek chhota bar chart ban jaata hai — visual comparison instant. Icons lagao — ▲ green arrow growth ke liye, ▼ red arrow decline ke liye. Professional reports mein conditional formatting MUST hai.

💡 5 Types of Conditional Formatting:
• Background Color: Cell ka background color change — green (high), yellow (medium), red (low). Color Scale (gradient) ya Rules (if > 50K → green).
• Font Color: Text ka color change — green text for positive growth, red for negative.
• Data Bars: Cell ke andar horizontal bar — length proportional to value. Excel jaisa in-cell bar chart.
• Icons: Arrows (▲▼), Flags (🚩), Traffic Lights (🟢🟡🔴), Stars — value ranges ke basis par.
• Web URL: Cell ko clickable link banana — URL column ki values clickable ban jaati hain.

💻 How to Apply:

// ═══════════════════════════════════════════
// APPLY CONDITIONAL FORMATTING
// ═══════════════════════════════════════════
// METHOD 1:
From Visual
// Select Table/Matrix → click column value dropdown (▼)
// → "Conditional Formatting" → choose type:
// Background Color / Font Color / Data Bars / Icons / Web URL

// BACKGROUND COLOR — Color Scale:
// Format by: Color Scale
// Minimum color: #FF0000 (Red) → for lowest value
// Maximum color: #00B050 (Green) → for highest value
// Middle color: #FFFF00 (Yellow) → optional midpoint
// Result: Gradient
from Red → Yellow → Green

// BACKGROUND COLOR — Rules:
// Format by: Rules
// Rule 1: If value >= 100000 → Green background
// Rule 2: If value >= 50000 AND
// Rule 3: If value

// DATA BARS:
// Positive bar color: Blue / Green
// Show bar only: OFF (show bar + value)
// Result: Each cell has horizontal bar + number

// ICONS:
// Style: Arrows (▲ → ▼) / Traffic Lights / Flags
// Rules: ▲ Green if >= 80%, → Yellow if >= 50%, ▼ Red if

// METHOD 2: Based
on a MEASURE (Advanced)
// Format by: Field Value
// Select a measure that returns color hex codes:
KPI Color =
SWITCH(
TRUE(),
[YoY Growth %] > 0.1, "#00B050",
[YoY Growth %] > 0, "#FFC000",
"#FF0000"
)
// This measure returns color codes based
on growth %
// Use it in Conditional Formatting → Field Value → KPI Color

⚠️ Common Mistakes:

• Mistake: Background aur Font dono same color — text invisible ho jaata hai. Fix: Light background mein dark text, dark background mein white text. Dono simultaneously test karo.
• Mistake: Data Bars bahut wide — number padh nahi paata. Fix: Data Bar ka "Show bar only" OFF rakho — bar ke saath number bhi dikhe.
• Mistake: Bahut zyada colors — rainbow effect, confusing. Fix: Max 3 colors use karo (Red-Yellow-Green ya similar). Simplicity = clarity.

💬 Interview Questions:

🔍 Definition: A Hierarchy in Power BI is a structured multi-level grouping that enables drill-down navigation. Automatic Hierarchy is created by Power BI when you add a Date column to a visual — it auto-generates Year → Quarter → Month → Day levels. Manual Hierarchy is created by you in the Fields Pane — drag columns to create custom levels (Category → Sub-Category → Product). Hierarchies enable users to navigate from summary to detail within the same visual using drill-down arrows.

🎯 Samjho Hinglish Mein: Hierarchy ek folder structure jaisi hai — Country folder ke andar State folders, State ke andar City folders. Power BI mein Bar chart mein drag karo "Country" — saare countries ki bars dikhein. Drill-down karo → States dikhein. Phir drill-down → Cities. Yeh multi-level exploration same visual mein hoti hai bina page change kiye. Auto hierarchy Power BI khud banata hai dates ke liye. Manual hierarchy tum banate ho — jaise Region → City ya Category → Sub-Category → Product.

💡 Auto vs Manual:
• Automatic Date Hierarchy: Power BI Date columns par auto-create karta hai: Year → Quarter → Month → Day. Convenient hai lekin model slow kar sakta hai (hidden tables create hota hai har date column ke liye). Disable karne ke liye: File → Options → Current File → Data Load → Uncheck "Auto date/time."
• Manual Hierarchy: Fields Pane mein — Right-click column → Create Hierarchy. Phir doosre columns drag karke hierarchy mein add karo. Full control — levels ka order tum decide karte ho. Best practice: Calendar table mein manual hierarchy banao (Year → Quarter → MonthName), auto hierarchy disable karo.

💻 Manual Hierarchy — Create:

// ═══════════════════════════════════════════ 
// CREATE MANUAL HIERARCHY
// ═══════════════════════════════════════════
// Date Hierarchy:
// 1. Fields Pane → Calendar table
// 2. Right-click "Year" → Create Hierarchy
// → "Year Hierarchy" created
// 3. Drag "Quarter" onto "Year Hierarchy"
// 4. Drag "MonthName" onto "Year Hierarchy"
// 5. Drag "Day" onto "Year Hierarchy" (optional)
//
// Result: Year Hierarchy
// ├── Year
// ├── Quarter
// ├── MonthName
// └── Day

// Product Hierarchy:
// Right-click "Category" → Create Hierarchy
// Drag "SubCategory" into it
// Drag "ProductName" into it
//
// Result: Category Hierarchy
// ├── Category (Electronics, Furniture...)
// ├── SubCategory (Laptops, Monitors...)
// └── ProductName (Dell Laptop, HP Monitor...)

// USE IN VISUAL:
// Drag entire hierarchy to Axis field
// Visual header shows drill arrows: ⬇ ⬆ ↕ ⊕

⚠️ Common Mistakes:

• Mistake: Auto date hierarchy ON rakhna + Calendar table bhi banana — duplicate hierarchies, confusion. Fix: Agar custom Calendar table banayi hai toh auto date/time disable karo (File → Options → Data Load). Ek source of truth rakho.
• Mistake: Hierarchy mein levels ka order galat — Month before Quarter. Fix: Hierarchy mein right-click → Move Up/Down se order fix karo. Broader → Specific hona chahiye.
• Mistake: MonthName alphabetically sort ho raha hai drill-down mein (April pehle, December baad mein). Fix: MonthName column ko MonthNum se "Sort by Column" set karo (Data View → Column Tools → Sort by Column).

💬 Interview Questions:

🔍 Definition: By default, slicers only affect the page they are on. Sync Slicers allows a slicer to synchronize its selection across multiple pages — so when a user selects "North" on Page 1, Page 2 and Page 3 automatically filter to "North" as well. You can control both Sync (same selection across pages) and Visible (whether the slicer appears on each page) independently. This creates a consistent filtering experience across multi-page reports.

🎯 Samjho Hinglish Mein: Tumhare dashboard mein 3 pages hain — Overview, Sales Detail, Product Analysis. Har page par Region slicer hai. User Page 1 par "North" select karta hai, phir Page 2 par jaata hai — wahan bhi "North" selected hona chahiye automatically. Bina Sync ke user ko har page par dobara "North" select karna padega — frustrating. Sync Slicers se ek baar select karo, saare pages par apply ho. Visible option se control karo ki slicer kaunse page par dikhe aur kaunse par nahi (lekin filter tab bhi apply ho).

💻 Sync Slicers — Setup:

// ═══════════════════════════════════════════ // SYNC SLICERS — Step by Step // ═══════════════════════════════════════════ // STEP 1: Select the slicer you want to sync // (e.g., Region slicer on Page 1) // STEP 2: View tab → Sync Slicers pane (opens side panel) // STEP 3: In Sync Slicers panel, you see all pages listed // Two columns: "Sync" and "Visible" //

⚠️ Common Mistakes:

• Mistake: Sync Slicers configure nahi karna — user har page par manually filter select karta hai. Fix: Important slicers (Region, Year, Category) ko saare relevant pages par sync karo.
• Mistake: Drill-through page par slicer sync karna — drill-through ka context override ho jaata hai. Fix: Drill-through pages par Sync OFF rakho — yeh pages apna context khud laate hain.
• Mistake: Har page par same slicer independently banana (sync nahi karna) — inconsistent filtering. Fix: Ek slicer banao ek page par, Sync karo baaki pages par. Alag alag slicers same column ke liye mat banao.

💬 Interview Questions:

🔍 Definition: Row Level Security (RLS) restricts data access at the row level based on user identity. Different users see different data from the same report — a North region manager sees only North data, a South manager sees only South data, while the VP sees all regions. RLS is defined using DAX filter expressions applied to roles, and roles are assigned to users in Power BI Service. It ensures data confidentiality without creating separate reports for each user.

🎯 Samjho Hinglish Mein: Ek company mein 4 Regional Managers hain — North, South, East, West. Sabko same Sales Dashboard access hai. Lekin North Manager ko sirf North ka data dikhna chahiye — woh South ka data na dekh sake. RLS yehi karta hai — ek filter lagata hai user ke login ke basis par. Report same hai, lekin har user ko sirf uska relevant data dikhta hai. IT team ko saara data dikhta hai. CEO ko bhi saara data dikhta hai. Regional Managers ko sirf apna region. Same report — different data per user.

💡 RLS — Key Concepts:
• Role: A named security role with a DAX filter expression. Example: "North Manager" role with filter [Region] = "North".
• DAX Filter: A TRUE/FALSE expression that filters which rows are visible. Applied to a table — rows where expression = TRUE are visible, FALSE rows are hidden.
• Static RLS: Hard-coded filter values — [Region] = "North". Need separate role for each region.
• Dynamic RLS: Uses USERPRINCIPALNAME() to automatically filter based on logged-in user's email. One role for everyone — scales automatically.
• Testing: Desktop mein "View as" → select role → test. Service mein users assign to roles.
• Deployment: Roles defined in Desktop, Users assigned in Power BI Service workspace.

💻 Static RLS — Setup:

// ═══════════════════════════════════════════ // STATIC RLS — Separate role per region // ═══════════════════════════════════════════
// STEP 1: Modeling tab → Manage Roles

// STEP 2: Create Role "North Manager"
// → Select Customers table
// → DAX Filter Expression:
[Region] = "North"
// → Save

// STEP 3: Create Role "South Manager"
[Region] = "South"

// STEP 4: Create Role "All Access" (CEO/Admin)
// → No filter expression (sees everything)

// STEP 5: Test in Desktop
// → Modeling tab → "View as" → Select "North Manager"
// → All visuals now show ONLY North data!
// → Click "Stop viewing" to exit test mode

// STEP 6: Publish to Power BI Service
// → Workspace → Dataset → Security
// → "North Manager" role → Add members (email addresses)
// → ravi.kumar@company.com → added!
// →
When Ravi logs in, he sees only North data

💻 Dynamic RLS — Scalable Approach:

// ═══════════════════════════════════════════ // DYNAMIC RLS — One role, auto-filter by user // ═══════════════════════════════════════════ // PREREQUISITE: Create a UserAccess table in your data // // UserAccess Table:

📊 Static vs Dynamic RLS:

⚠️ Common Mistakes:

• Mistake: RLS test nahi karna publish se pehle — users ko wrong data dikhta hai. Fix: "View as" role se HAMESHA test karo Desktop mein. Service mein bhi "Test as" use karo.
• Mistake: USERPRINCIPALNAME() Desktop mein test karna — apni email return karta hai. Fix: "View as" mein "Other user" option hai — doosre user ki email enter karke test karo.
• Mistake: RLS role banaya lekin Service mein users assign nahi kiye. Fix: Workspace → Dataset → Security → Role select → Members add karo. Bina assignment ke RLS inactive hai.
• Mistake: UserAccess table mein email case mismatch — "Ravi@company.com" vs "ravi@company.com". Fix: LOWER function use karo: LOWER([Email]) = LOWER(USERPRINCIPALNAME()). Case-insensitive comparison.

💬 Interview Questions:

7 Parts, 50 Topics — Power BI ka complete journey ek nazar mein:

🎉 Power BI Masterclass — COMPLETE!

7 Parts mein 49 topics cover kiye — Power BI ka Introduction se lekar Row Level Security tak. Theory heavy approach ke saath DAX deep coverage, real-world scenarios, aur production-ready measures. Yeh masterclass Data Insights blog series ka ek aur milestone hai. Previously completed on Data Insights: MySQL Masterclass (7 Parts), Pandas, Data Cleaning + Statistics, Matplotlib, Seaborn, Plotly, NumPy Masterclass (3 Parts), Excel Masterclass (8 Parts) — aur ab Power BI Masterclass (7 Parts)!

Happy Learning & Keep Analyzing! 🚀
— Data Insights by Jatin Analytics