Business Intelligence with Power BI

L09 · Interactivity

Practice — Mild · Solution

Verified checkpoints

CheckValue
Furniture drillStorage $6,810,205 · Bedroom $6,229,512 · Seating $5,893,253 · Tables $5,865,136
Filtered card on Furniture click$24.80M (the L09 escalation number, now produced on purpose)
Reset buttonRestores slicers, drill level, and cross-filter state to the designed page
Drillthrough"Detail: Furniture" title; all four visuals narrowed; back button returns

Reflection answers

  • $24.80M is the topic page's escalation story — the forgotten-click number a director reported as "broken data." Two things on this page prevent the rerun: the card now visibly changes when clicked context changes (Filter, not Highlight — the state is at least consistent), and the reset button gives any confused reader a one-click way home.
  • Because the page can be reached without a single category in context — a direct tab click, or a drill from a multi-category state. SELECTEDVALUE returns blank when it cannot name one value; the fallback turns that blank into an honest label instead of an empty title. Fallbacks are the title's own error handling.