Power BI Advanced Features¶

Advanced Power BI capabilities including custom themes, visuals from AppSource, What-If parameters for scenario analysis, drill-through navigation, bookmarks for storytelling, and advanced DAX patterns.

Key Facts¶

Custom themes via JSON files for brand compliance and accessibility
Custom visuals from AppSource marketplace (.pbiviz format)
What-If parameters create slicer-driven scenario analysis
Drill-through enables summary-to-detail navigation via right-click
Bookmarks capture report state (filters, page, visibility) for navigation and storytelling
Performance Analyzer identifies slow visuals

Patterns¶

Custom Themes¶

{
  "name": "MyTheme",
  "dataColors": ["#118DFF", "#12239E", "..."],
  "background": "#FFFFFF",
  "foreground": "#252423",
  "tableAccent": "#118DFF"
}

Apply: View -> Themes -> Browse for themes (JSON file) or select from gallery. Theme generators available as web tools.

What-If Parameters¶

Create: Modeling -> New Parameter -> set name, data type, min, max, increment, default.

Creates automatically: a new table with single-column range + a slicer + a measure for selected value.

-- Auto-created
Discount Rate = SELECTEDVALUE('Discount'[Discount], 0)

-- User-created measure using the parameter
Revenue After Discount = [Total Revenue] * (1 - [Discount Rate])

Metric switcher pattern (select which metric to display via slicer):

Selected Metric =
SWITCH(
    SELECTEDVALUE('Metric Selector'[Metric]),
    "Revenue", [Total Revenue],
    "Profit", [Total Profit],
    "Orders", [Order Count]
)

Drill-Through¶

Setup: 1. Create detail page 2. Drag dimension field to "Drill-through" section of Filters pane 3. On summary pages: right-click data point -> Drill through -> [page name]

Filter is passed automatically. A "Back" button appears on detail page.

Use case: region totals -> click region -> see all transactions in that region.

Bookmarks¶

Captures: current page, filters, slicer values, visual visibility.

Create: View -> Bookmarks pane -> Add bookmark.

Common patterns: - Storytelling: sequence of bookmarks as guided narrative - Custom navigation: buttons with "Bookmark" action replace default page tabs - Conditional navigation: button shows different page based on slicer - Visual type toggle: show chart OR table of same data via bookmark + selection visibility - Rich tooltips: create hover tooltips using SVG images

Button actions: Bookmark, Page navigation, Q&A, Drill-through, Web URL.

Advanced DAX¶

FORMAT function:

Sales Label = FORMAT([Total Sales], "$#,##0.00")
Month Name = FORMAT(Date[Date], "MMMM YYYY")

Conditional formatting via DAX:

KPI Color = IF([Actual] >= [Target], "#28A745", "#DC3545")

Apply: Visualizations -> Value field -> Conditional formatting -> Field value.

Calculated tables:

Date Table = CALENDAR(DATE(2020,1,1), DATE(2025,12,31))
Top 10 Customers = TOPN(10, Customers, [Total Revenue], DESC)

Performance Optimization¶

Use Performance Analyzer: View -> Performance Analyzer.

Optimization techniques: - Prefer Import mode over DirectQuery for large aggregations - Reduce column cardinality (remove unused columns) - Pre-aggregate in Power Query before loading - Use integer surrogate keys in relationships instead of text keys - Avoid bidirectional relationships unless required - Move complex calculations to Power Query (M) instead of DAX measures

Gotchas¶

Custom visuals from AppSource may not support all formatting options or may behave differently in Power BI Service vs Desktop
What-If parameters create actual tables in the model - many parameters = model bloat
Bookmarks capture visual visibility state, which can break if you add/remove visuals after creating bookmarks
Drill-through only works on data points that match the drill-through filter dimension
Performance Analyzer measures may vary between Desktop and Service due to different query engines