Business Intelligence with Power BI

L09 · Interactivity

Practice — Mild · Cockpit Rehearsal

Skills focus. A09's two pages, built with the guardrails up.

Ungraded. Start from your A08 model.

Tasks

  1. Explore page: Year and Region slicers · category bar with the Category → Subcategory hierarchy · monthly line · [Total Revenue] card. Check: drilling into Furniture shows Storage $6.81M leading four near-equal bars.
  2. Audit interactions: Format → Edit interactions, with the bar selected — set the line and card to Filter. Click Furniture: the card must read $24.80M (not a highlighted $66.81M). Click empty canvas to release.
  3. Reset: capture the pristine page as a bookmark ("Reset — Explore"), add a button applying it. Make a mess; press the button; confirm the page comes home.
  4. Category Detail page: drillthrough on Category · the Detail Title measure with SELECTEDVALUE and an "All Categories" fallback · subcategory bar, monthly line, [Return Rate] card, top-10 table. Check: right-click Furniture on Explore → Drill through: title reads "Detail: Furniture", every visual narrows, back button returns.
Hint — my detail title reads "All Categories" after drilling

SELECTEDVALUE sees more than one value — the drillthrough field is not set on the page (check the Drillthrough well in the Visualizations pane), or you navigated by page tab instead of right-click → Drill through.

Reflection

  • Step 2's click produced $24.80M on the card. Where have you seen that exact number cause trouble, and what on this page now prevents the rerun?
  • Why does the Detail Title need the fallback argument at all?