📎 This article includes 3 downloadable practice files ↓
In this article
Drill-through
- New page “Customer detail” with cards (Total Sales, Orders), a monthly chart and an orders table.
- Drag
Customers[Customer]into the page’s Drill through well. - On any visual showing customers: right-click > Drill through > Customer detail.
Drilling to Sharma Traders should show ₹35,19,865 and 80 orders. A back button is added automatically.
Tooltip pages
New page > Page information: Allow use as tooltip; Canvas settings: Type = Tooltip. Add a small chart and the field Products[Product] to the tooltip well. Hovering over Laptop anywhere now shows its mini-page (258 units sold in the practice data).
Bookmarks
View > Bookmarks. Set up the page for “Sales view”, Add; hide/show visuals for “Profit view”, Add. Insert two buttons, Action = Bookmark. Use Selection pane visibility, and untick “Data” on a bookmark if it should not reset the slicers.
Practice
Import pbi-intermediate-model.xlsx into Power BI Desktop (free), create the relationships listed at the top of the .dax file, mark the Date table as a date table and add this lesson’s measures. Compare your card and table values with the lesson’s sheet in the expected-results file. Those numbers were worked out independently in Python from the same data, so a mismatch means a filter or relationship to check.
📎 Practice files for this article
⬇ Download all 3 files (ZIP · 61 KB)
- 📗Practice model (Excel)Two years of sales (700 orders, FY 2024-25 and 2025-26) with Customers, Products, a full Date table, Targets and RegionUsers.⬇ XLSX · 63 KB
- 📄Lesson 9 measures (.dax)Every measure from this lesson, ready to paste into Power BI Desktop.⬇ DAX · 802 B
- 📗Expected resultsThe numbers your measures should show, one sheet per lesson.⬇ XLSX · 11 KB
Free to use for learning. Files with macros (.bas) are plain text — import them with Alt+F11 → File → Import File, and always test on a copy.
Stuck on a step? Ask a question and the AI answers using this article.