Business Intelligence with Power BI

L09 · Interactivity

Practice — Medium · State Bugs, Planted and Fixed

Skills focus. The two classic interactivity bugs — the greedy bookmark and the half-listening page — built, experienced from the reader's side, and repaired.

Ungraded. Continue from Mild's finished pages.

Part 1 — The greedy bookmark

  1. Add a second card ([Total Units]) on Explore, hidden by default. Create "Units view" / "Revenue view" buttons with bookmarks that swap card visibility — but for the first attempt, capture the bookmarks with Data included (the default).
  2. Now play the reader: select Region = Midwest, then press "Units view." Watch your slicer. Write down what the bookmark just did to the reader's context.
  3. Fix it: recapture both bookmarks with Display only (uncheck Data). Repeat the test; the Midwest selection must survive the view switch.

Part 2 — The half-listening page

  1. On Category Detail, select the top-10 products table and sever its response to the drillthrough context (Format → Edit interactions from the drill filter's perspective, or simply add an ALL-based override — either produces the disease; note which lever you pulled).
  2. Drill through on Decor from Explore. Read the page as a hostile reviewer: which visuals are Decor's, which are the company's, and what does the title claim about all of them?
  3. Repair, re-drill, verify all four visuals narrow together.

Reflection

  • Both bugs rendered without errors and survived a casual glance. What reading habit caught each — and which figure did you watch?
  • Part 1's bug hurt the reader's trust in buttons; Part 2's hurt trust in titles. Which is more expensive to a report's credibility, and why?