Drill-Down, Drill-Through & Tooltips
Power BI · Data Visualization
Theory
Power BI offers three ways to reveal more detail on demand. Drill-down works inside one visual that has a hierarchy on its axis, such as Year → Quarter → Month or Category → Product: with drill mode on, clicking a bar moves to the next level, so clicking Electronics shows Headphones and Keyboard. You can create a hierarchy in the Data pane by dragging one column onto another.
Drill-through jumps to a separate detail page. You add a field, for example Customers[Name], to the target page's Drill-through well; then right-clicking Asha anywhere in the report and choosing Drill through opens that page filtered to Asha, and a back button returns. Tooltips appear on hover: by default they list the visual's fields, but a report page tooltip is a small page that shows its own visuals, such as a mini trend for the hovered region.
Why we use it
Summary pages stay clean while detail is one click away. Users explore from overview to specifics without leaving the report or building extra filters.
When to use it
Use drill-down for natural hierarchies within one chart, drill-through for a full detail page about one item (customer, product), and tooltips for quick context without clicking. Do not hide essential information only in tooltips; they are not visible on touch screens until tapped.
How it works
- User wants more detail
- Stay in the same chart, next hierarchy level? Yes: Drill down. No: Continue.
- Need a full page about one item? Yes: Drill through to the detail page. No: Hover for a tooltip.
- Detail is shown with the right filters
- Return via back button or drill up
Syntax
Hierarchy: Data pane → right-click column → Create hierarchy (or drag a column onto another)
Drill-down: visual header → down-arrow (drill mode) or right-click → Drill down
Drill-through: target page → Visualizations → Drill through well → add field
Page tooltip: Format page → Page information → Allow use as tooltip; then visual → Format → General → Tooltips → Type: Report pageExample
1. Create hierarchy: Products[Category] → Products[Product].
2. Bar chart with the hierarchy and [Total Sales]: Electronics ₹4,200, Home ₹2,000.
3. Drill mode on, click Electronics → Headphones ₹1,800, Keyboard ₹2,400.
4. New page 'Customer Detail': add Customers[Name] to Drill through.
5. On any page right-click Asha → Drill through → Customer Detail shows her 2 orders, ₹2,700.Key points
- Drill-down moves through a hierarchy inside one visual
- Drill-through opens a detail page filtered to the clicked item
- Drill-through pages get an automatic back button
- Report page tooltips show custom visuals on hover
- Keep all filters option passes other filters into drill-through