Assignment A09 — The Cockpit and the Doorway
Skills assessed. Slicers vs pane scoping · edited interactions · drill
hierarchy · a drillthrough page with a dynamic title · reset bookmark · the
exploration/answer distinction.
Submit: A09_LastFirst.pbix. Worth 20 points. Start from your A08 model.
This is the interactivity core of your eventual capstone — build it to keep.
Requirements
- Page "Explore" (an exploration page):
- Slicers: Year (from Dates) and Region
- A category bar with a Category → Subcategory hierarchy (drill enabled), a monthly trend line, and the [Total Revenue] card
- Interactions audited: clicking the bar must Filter the line and the card (no highlighted cards anywhere)
- A "Clear filters" button applying a reset bookmark that restores the pristine state
- Page "Category Detail" (a drillthrough destination):
- Drillthrough field: Category
- Dynamic title measure:
Detail Title = "Detail: " & SELECTEDVALUE ( Products[Category], "All Categories" ) - Contents: subcategory bar, monthly line, [Return Rate] card, top-10 products table — all responding to the drill filter (Q18's half-listening page is an automatic fail of this item)
- Back button present
- Prove the doorway: from Explore, drill through on Furniture. The detail page must read "Detail: Furniture" with Storage leading the subcategory bar at $6.81M.
Checklist (what the grader checks)
| # | Check | Points |
|---|---|---|
| 1 | Explore: slicers, hierarchy bar (drill enabled), line, card present | 4 |
| 2 | Interactions: bar→line and bar→card set to Filter; no Highlight on any card | 4 |
| 3 | Reset bookmark + button restores designed state | 3 |
| 4 | Category Detail: drillthrough field set; Detail Title measure exists with SELECTEDVALUE and fallback | 4 |
| 5 | All four detail visuals respond to the drill filter (Furniture → Storage $6.81M top) | 3 |
| 6 | Back button present on the detail page | 1 |
| 7 | File named A09_LastFirst.pbix | 1 |
Before you submit
- Play the hostile reader: click the weirdest sequence you can, then hit your reset button. Does the page come all the way home?
- Drill through on Decor too — the title must follow. A title stuck on Furniture means the measure captured a value instead of reading context.
- Save, close, reopen, verify.