Module 7: Visuals and report design · Lesson 7.3 · about 14 min
Drill down, drill through and tooltips
Let readers go from summary to detail without crowding the page. Set up hierarchies to drill down, drill-through pages for one item's details, and tooltip pages that appear on hover.
Module 7 · about 14 minutes · read first: 7.2. You’ll be able to give readers detail on demand: drill down, drill through and tooltip pages.
1. Why this matters
A good report shows the summary first and details when asked. Cramming every detail onto one page makes it unreadable; these three features keep it clean.
2. Drill down
Put several fields from a hierarchy on an axis, for example Date: Year, Quarter, Month. The visual shows years; the drill arrows let readers go down a level (all months) or expand a chosen year. Make your own hierarchy in the Data pane: right-click Year > Create hierarchy, then add Quarter and Month to it. Turn off the automatic date hierarchy (auto date/time) and build this one on your own date table.
3. Drill through
- Make a page called “Store detail”.
- In its Build pane, drag
Store[Store]into Drill through. Power BI adds a Back button. - Build the page with store-level visuals: trend, category mix, product table.
- On any other page, right-click a store (a bar, a table row) > Drill through > Store detail. The page opens filtered to that store.
Use a title measure on the detail page so it says which store it’s showing (SELECTEDVALUE(Store[Store])).
4. Tooltip pages
- New page; in Format > Page information, turn on Allow use as tooltip; in Canvas settings choose the Tooltip size.
- Put a few small visuals on it: a mini trend, the top product, margin %.
- On the main chart: Format > Properties > Tooltips > Type Report page, choose the page.
Now hovering over a store shows its mini summary. A measure like this is typical on a tooltip page:
A tooltip page often shows a small summary for the hovered item. Write Top Product: the name of the best-selling product in the current context, with CONCATENATEX(TOPN(1, VALUES(Product[Product]), [Total Sales]), Product[Product], ", ").
Press Run to see the result.
Total Sales = SUM(Sales[Amount])
Top Product = CONCATENATEX(TOPN(1, VALUES(Product[Product]), [Total Sales]), Product[Product], ", ") Principle
Principle: drill through and tooltips pass the hovered or right-clicked item to another page as a filter. On that page, every measure is evaluated in a filter context that includes that item, so the same measures give that item’s numbers.
Try it: a tooltip page shows Total Sales and the hovered bar is Rideau in 2025. Which filter context does the tooltip’s card use? (Store = Rideau and Year = 2025, plus any page slicers.)
5. Worked example
From chain to product in three clicks. Overview page: sales by region. Right-click West > drill through to Region detail: sales by store. Right-click Harbour Front > drill through to Store detail: product table and trend. Hover a product: tooltip with its 28-day trend. No page has more than five visuals.
6. Practice
- Make a Date hierarchy Year > Quarter > Month and use it on a column chart.
- Set up a drill-through page for Product[Category].
- What does the Back button on a drill-through page do?
Answers
- Right-click ‘Date’[Year] > Create hierarchy, then drag Quarter and Month into it.
- New page, drag Product[Category] into the Drill through well, build the visuals.
- Returns to the page the reader came from (Ctrl+click in Desktop).
Check yourself
Your ticks stay in this browser. Save them as a file on the course home.
Updated 2026-11-22. Northbay Goods is a made-up shop and its numbers are generated. Power BI changes every month: menu names can move, so check Microsoft Learn if a button is not where the lesson says. The practice editor runs in your browser; nothing you type is sent anywhere.