Drill-Down and Drill-Through
Drill-down and drill-through are two distinct navigation patterns in Power BI that let users move from summary to detail, but they operate at different scopes: drill-down works within a single visual's hierarchy, while drill-through jumps to an entirely different report page carrying filter context with it.
Cricket analogy: Drill-down is like zooming a single broadcast camera from a wide shot to a close-up on the same feed, while drill-through is like the director cutting to an entirely different dedicated player-stats channel.
Drill-Down Within a Visual
Drill-down requires a hierarchy-either a built-in date hierarchy or a custom hierarchy built by dragging fields like Category > Subcategory > Product into the same visual-and users click the drill-down arrow or double-click a data point to expand one level deeper while the visual type stays the same.
Cricket analogy: Drilling down from Season into Match into Innings mirrors watching a wicket replay progressively zoom from the full over, to the specific ball, to the exact seam position - each click reveals one more level of detail.
The "Expand all down one level in the hierarchy" and "Show next level" options change whether drilling replaces the current level or shows both levels together, which matters for a stacked column chart where showing all levels at once can produce misleading category counts.
Cricket analogy: "Show next level" on a stacked column of runs by Format then Player replaces Format entirely with Player bars, while "Expand all" keeps both together, similar to a broadcast graphic that either replaces the scorecard entirely or overlays it on the existing one.
Drill-Through to a Detail Page
A drill-through page is a normal report page configured with a field in the Drillthrough well of the Filters pane; when a user right-clicks a data point on the source page and selects "Drill through," Power BI navigates to that page pre-filtered to the clicked value, and a back button (auto-added) returns to the source.
Cricket analogy: Right-clicking a player's bar on a summary chart and selecting "Drill through" to a Player Detail page mirrors a commentator cutting to a dedicated player-profile graphic mid-broadcast, with a back button returning to the main scorecard view.
Cross-report drill-through (Power BI Service, Premium/PPU) extends this pattern across separate .pbix files, and keep-all-filters is a per-drillthrough-page setting that determines whether upstream filters beyond the clicked field also carry through, which can cause an empty detail page if misconfigured.
Cricket analogy: Enabling "Keep all filters" on a drillthrough page can leave it blank if an upstream Format filter (say, T20-only) conflicts with the clicked player's Test-only career, the way a highlights search filtered by both "ODI" and "Kohli's Test centuries" returns nothing.
Tooltip pages are a related but distinct feature: a small report page shown on hover (not click) that summarizes context without navigating away, configured via the Page Information pane's 'Allow use as tooltip' setting rather than the Drillthrough well.
A drillthrough page with 'Keep all filters' enabled can render completely blank if any upstream filter conflicts with the clicked data point's own attributes-always test drillthrough with multiple upstream filter combinations before shipping a report.
Drillthrough Page Title =
"Details for: " & SELECTEDVALUE(Players[PlayerName], "Multiple Players")- Drill-down navigates within a single visual's hierarchy; drill-through navigates to a separate report page.
- Drill-down requires a hierarchy of fields (built-in date hierarchy or a custom one) added to the visual.
- "Show next level" replaces the current level; "Expand all down one level" nests both levels together.
- Drillthrough pages are configured via the Drillthrough well in the Filters pane.
- Drillthrough carries the clicked value's filter as context; a back button is added automatically.
- Cross-report drillthrough (Premium/PPU) extends the pattern across separate .pbix files.
- "Keep all filters" can produce an empty drillthrough page if upstream filters conflict with the clicked value.
Practice what you learned
1. What is required in a visual before a user can drill down within it?
2. Where is a drillthrough target page configured?
3. What can cause a drillthrough page to appear completely empty?
4. What is the difference between "Show next level" and "Expand all down one level" when drilling down?
Was this page helpful?
You May Also Like
Slicers and Filters
How Power BI's three filtering layers-slicers, visual filters, and page/report filters-combine, sync, and interact with DAX filter-context functions.
Custom Visuals
How to source, vet, and build custom Power BI visuals beyond the built-in gallery, from AppSource certification to the pbiviz SDK.
Choosing the Right Visual
How to match Power BI visual types to the shape of your data and the question you're actually answering, and the common chart-selection mistakes to avoid.
Related Reading
Related Study Notes in Programming
Browse all study notesApache Spark Study Notes
Programming · 30 topics
ProgrammingApache Flink Study Notes
Programming · 30 topics
ProgrammingHadoop Study Notes
Programming · 30 topics
ProgrammingSnowflake Study Notes
Programming · 30 topics
ProgrammingApache Airflow Study Notes
Programming · 30 topics
Programmingdbt (Data Build Tool) Study Notes
Programming · 30 topics