Power BI Drillthrough vs Drilldown: Complete Guide 2026
Expert Insight from Errin O'Connor
28+ years Microsoft consulting | 4x Microsoft Press bestselling author (including Power BI) | Former NASA Lead Architect | 200+ enterprise Power BI implementations across healthcare, finance, and government
Quick Answer
Drill down navigates deeper within a single visual's hierarchy (Year → Quarter → Month). Drillthrough navigates from a summary visual to a detailed report page filtered by the selected data point. Both are essential for interactive Power BI reports. Drilldown expands a hierarchy in place. Drillthrough jumps to a different page with full context. This guide covers setup steps, comparison, advanced cross-report drillthrough, and enterprise best practices from 200+ Power BI implementations.
Drillthrough vs Drilldown: Side-by-Side Comparison
The most common confusion in Power BI report design is when to use drillthrough versus drilldown. They solve different problems. The table below provides a definitive comparison across every dimension that matters for enterprise report design.
| Feature | Drilldown | Drillthrough |
|---|---|---|
| Purpose | Explore hierarchy levels within one visual | Navigate to a detail page for a specific data point |
| Navigation | Stays within the same visual | Jumps to a different report page |
| Setup Location | Add hierarchy fields to the visual's axis/category | Drillthrough filters well on the target page |
| User Action | Click drill-down arrows or double-click a data point | Right-click a data point → Drillthrough menu |
| Data Scope | Same dataset, deeper hierarchy level | Same or different report, filtered to selected value |
| Cross-Report | Not supported | Supported (cross-report drillthrough) |
| Back Navigation | Drill-up arrow in visual header | Auto-generated back button on target page |
| Best Use Case | Time hierarchies, geographic breakdowns | Customer detail, product breakdown, regional analysis |
| Mobile Support | Full support via tap on drill icons | Long-press required (less discoverable) |
| Performance Impact | Minimal (same visual, additional filter) | Moderate (loads new page with all visuals) |
What Is Drilldown in Power BI?
Drilldown lets users explore data at progressively deeper levels within a single visual. A bar chart showing revenue by year can drill down to quarters, then months, then individual days. The visual stays in place. Only the granularity changes.
Drilldown requires a hierarchy in the data model. Power BI supports two types: built-in date hierarchies that Power BI creates automatically for date columns, and custom hierarchies that you define by nesting fields (Country → State → City → Store). Any visual that accepts a category axis supports drilldown when multiple hierarchy levels are present.
The visual header provides four drill controls. The single down arrow drills down one level for the selected data point. The double down arrow expands the entire visual to the next level. The up arrow returns to the previous level. The split arrows toggle between drill mode and regular selection mode. Understanding these four controls is essential for building reports that users can navigate confidently.
How to Set Up Drilldown in Power BI
Follow these steps to configure drilldown in Power BI Desktop. This process works for bar charts, column charts, line charts, maps, matrices, and treemaps.
Step-by-Step: Configure Drilldown
- 1Create or identify your hierarchy. In the Fields pane, right-click a field like Country and select "New hierarchy." Drag State, City, and Store into the hierarchy in order from broadest to most granular.
- 2Add the hierarchy to a visual. Create a bar chart, column chart, or matrix. Drag the entire hierarchy (not individual fields) into the Axis or Rows well of the visual.
- 3Add a measure to the Values well. Drag a numeric field like Revenue or Quantity into the Values area. This is the metric that updates as users drill through hierarchy levels.
- 4Enable drill mode. Hover over the visual to see the drill icons in the header. Click the single down-arrow to enable drill mode. Now clicking any bar will drill into the next level for that specific item.
- 5Test the drill path. Click a data point (e.g., "United States") to drill into states. Click a state to drill into cities. Click the up arrow to return. Verify the data is correct at each level.
- 6Configure expand behavior (optional). The double-down arrow expands all data points to the next level simultaneously. This is useful for matrix visuals where users want to see all regions broken down by state at once.
For date-based drilldown, Power BI generates automatic hierarchies on date columns with Year, Quarter, Month, and Day levels. Disable this in File → Options → Current File → Data Load if you prefer custom date hierarchies that match your fiscal calendar. EPC Group recommends custom date tables for enterprise deployments because they support fiscal years, custom periods, and business-specific date logic.
What Is Drillthrough in Power BI?
Drillthrough navigates users from a summary page to a detail page filtered by the data point they selected. A user viewing a sales summary by region right-clicks "West Region" and drills through to a detail page showing every transaction, salesperson, and product for that region. The detail page provides comprehensive context that would clutter the summary page.
Drillthrough is the primary navigation pattern for enterprise Power BI reports that need to support both executive summaries and operational detail. Executives see KPIs and trends on the summary page. Analysts and managers right-click to access the granular data behind any metric. This two-tier design keeps reports clean while providing depth on demand.
How to Set Up Drillthrough in Power BI
Follow these steps to configure drillthrough navigation in Power BI Desktop. This works across all visual types and supports both single-field and multi-field drillthrough filters.
Step-by-Step: Configure Drillthrough
- 1Create the detail page. Add a new page to your report and name it descriptively, such as "Detail - Customer" or "Detail - Product." This naming convention tells users what detail they will see when they drill through.
- 2Add drillthrough filters. On the detail page, find the Drillthrough section in the Visualizations pane (below the standard Filters section). Drag the field you want to filter on (e.g., Customer Name, Product Category, Region) into the Drillthrough well.
- 3Configure "Keep all filters" toggle. Decide whether existing page-level and report-level filters should carry over. Enable this for reports where date range and department context must persist. Disable it for standalone detail pages.
- 4Build detail visuals. Add tables, charts, KPI cards, and any other visuals that show the detail information for the drilled-through item. These visuals automatically filter to the selected value when a user drills through.
- 5Verify the back button. Power BI automatically adds a back button to the top-left of the drillthrough page. Customize its position, size, and formatting to match your report theme. Do not delete it.
- 6Test drillthrough from the source page. Navigate to any page with a visual containing the drillthrough field. Right-click a data point and confirm the drillthrough option appears in the context menu. Select it and verify the detail page loads with the correct filter applied.
- 7Hide the detail page (optional). Right-click the page tab and select "Hide page." This prevents users from navigating to the detail page directly. They can only reach it through the drillthrough action, ensuring the page always has context.
When to Use Drilldown vs Drillthrough
Choosing between drilldown and drillthrough depends on the analytical question users are asking. The decision is straightforward once you understand the pattern.
Decision Guide
Use Drilldown when: Users need to break down a single metric across hierarchy levels. Revenue by Year drilling into Quarters. Sales by Country drilling into States. Headcount by Department drilling into Teams. The visual type stays the same. The axis changes granularity.
Use Drillthrough when: Users need a complete profile or breakdown of a specific item. A customer detail page showing all orders, support tickets, and lifetime value. A product page showing sales by channel, returns, and profitability. A regional analysis page showing team performance, pipeline, and targets.
Use both together when: A report needs hierarchical exploration and entity detail. A sales dashboard with drilldown on the time axis (Year → Quarter → Month) and drillthrough to individual account detail pages. This combination covers the two most common analytical workflows in enterprise reports.
Enterprise reports from EPC Group typically use drilldown on 2-3 time-based visuals and drillthrough to 3-5 detail pages. This ratio provides sufficient depth without overwhelming users with navigation complexity. For more on enterprise Power BI design patterns, see our Power BI Governance Framework Guide.
Advanced Pattern: Cross-Report Drillthrough
Cross-report drillthrough extends the drillthrough concept across separate Power BI reports. A user viewing an executive summary report can right-click a business unit and drill through to a detailed operational report in a completely different .pbix file. This is the most powerful navigation pattern in enterprise Power BI because it lets you separate concerns: summary dashboards stay clean, and detail reports stay comprehensive.
Setting Up Cross-Report Drillthrough
- 1Publish both reports to the same workspace. Cross-report drillthrough requires both the source and target reports to exist in the same Power BI workspace in the service.
- 2Enable cross-report drillthrough on the target page. In the target report, go to the drillthrough detail page. In the Drillthrough section of the Visualizations pane, toggle "Cross-report" to On.
- 3Match field names across data models. The drillthrough filter field in the target report must match the field name in the source report's data model. If the source uses "Region" and the target uses "Sales Region," cross-report drillthrough will not work.
- 4Publish and test in the service. Cross-report drillthrough only works in Power BI Service, not in Power BI Desktop. After publishing, open the source report in the service, right-click a data point, and verify the cross-report drillthrough option appears.
Cross-report drillthrough is ideal for organizations that maintain separate reports for different business functions. A finance team owns the financial detail report. A sales team owns the pipeline detail report. The executive dashboard links to both through cross-report drillthrough without either team needing to modify the other's report.
Advanced Pattern: Drillthrough with Measures
Power BI supports using measures as drillthrough filters, not just dimension fields. This enables scenarios where users drill through based on a calculated value rather than a category. For example, a user can right-click a KPI card showing "Customer Churn Rate" and drill through to a page listing all churned customers with their details.
To use a measure as a drillthrough filter, drag the measure into the Drillthrough well on the target page. When a user right-clicks a visual that includes that measure, the drillthrough context passes the filtered value of the measure. This pattern is advanced and requires careful DAX to ensure the detail page calculates correctly with the passed filter context.
EPC Group uses measure-based drillthrough in financial reports where executives need to drill from a summary KPI (like gross margin percentage) into the underlying transactions that produced that number. The key is writing DAX measures on the detail page that respect the drillthrough filter context using ISFILTERED() and SELECTEDVALUE() functions to adapt their behavior based on whether the page was reached through drillthrough or direct navigation.
Common Mistakes and How to Fix Them
Mistake 1: Drillthrough option does not appear in the right-click menu
The drillthrough field on the target page must exist in the source visual's data model. If the source visual does not contain the drillthrough field (even as an unused field in the dataset), the option will not appear. Fix: ensure both visuals use the same dataset or that the field name matches exactly across datasets.
Mistake 2: Drilldown shows blank or zero values at lower levels
This happens when the hierarchy fields have null values or when relationships between tables are not configured correctly. Fix: check for null values in hierarchy columns using Power Query and verify that table relationships use the correct cardinality and cross-filter direction in the model view.
Mistake 3: Drillthrough page shows all data instead of filtered data
The drillthrough field was added to the regular Filters pane instead of the Drillthrough section. Fix: remove the field from page-level filters and place it exclusively in the Drillthrough well in the Visualizations pane. The Drillthrough section is separate and located below the standard filter areas.
Mistake 4: Back button is missing from the drillthrough page
The back button is auto-generated when you add a drillthrough filter. If it was accidentally deleted, you can recreate it: add a button visual, set its Action type to "Back," and position it in the top-left corner. The back button is critical for user navigation and must always be present.
Mistake 5: Cross-report drillthrough fails silently
Cross-report drillthrough only works in Power BI Service, not Desktop. Both reports must be in the same workspace, and field names must match exactly. Fix: verify the workspace, enable the cross-report toggle, and rename fields to match between the source and target data models.
Mistake 6: Too many hierarchy levels causing user confusion
Hierarchies with 5+ levels disorient users who lose track of their position. Fix: limit hierarchies to 4 levels maximum. If deeper granularity is needed, combine drilldown (3-4 levels) with drillthrough to a detail page for the lowest level. Add breadcrumb-style titles using DAX that show the current drill path.
Drillthrough and Row-Level Security
Enterprise Power BI deployments must verify that drillthrough pages respect row-level security (RLS). When a user drills through from a summary page, the detail page inherits the RLS context of the current user. This means a regional manager who can only see West Region data on the summary page will only see West Region data on the drillthrough detail page.
However, testing is mandatory. EPC Group tests every drillthrough page by impersonating different RLS roles in Power BI Desktop to confirm that unauthorized data never appears on detail pages. The most common RLS failure with drillthrough occurs when the detail page uses a different dataset that does not have RLS configured. Always use a shared dataset or live connection to ensure consistent security enforcement. For comprehensive RLS guidance, see our Power BI Governance Framework Guide.
Drillthrough with Buttons and Bookmarks
Right-click drillthrough is not always discoverable, especially for business users unfamiliar with Power BI. EPC Group supplements right-click drillthrough with button-based navigation using Power BI bookmarks and button actions.
Add a button to the summary page labeled "View Details" that uses a Page navigation action to go to the drillthrough page. Combine this with a slicer or selection that filters the detail page to the relevant context. This approach works better on mobile devices where right-clicking is replaced by a long-press that many users never discover.
For enterprise report templates, EPC Group creates a standard navigation pattern that includes both right-click drillthrough (for power users) and button navigation (for casual users). This dual approach ensures 100% of users can access detail pages regardless of their Power BI proficiency. Our Power BI consulting team implements this pattern in every enterprise deployment.
Performance Optimization for Drillthrough Pages
Drillthrough pages load all their visuals when a user navigates to them. A detail page with 15 visuals will fire 15 queries simultaneously, causing slow load times that frustrate users. EPC Group follows a strict performance budget for drillthrough pages.
Keep drillthrough pages under 8 visuals. Use card visuals for KPIs (they query fast) and limit table visuals to 500 rows with pagination. Avoid complex DAX calculations that iterate large tables on drillthrough pages. Pre-aggregate data in the model using calculated tables or dataflows for detail pages that need to show large datasets. Test drillthrough page load time with DAX Studio using the Server Timings feature to identify slow queries.
For DirectQuery models, drillthrough performance depends on the source database. Add indexes on the drillthrough filter columns in the source database to ensure filtered queries execute in under 2 seconds. Import mode and composite models provide the fastest drillthrough experience because the data is pre-loaded into the VertiPaq engine.
Frequently Asked Questions
What is the difference between drillthrough and drilldown in Power BI?
Drilldown navigates deeper within a single visual's hierarchy, such as Year to Quarter to Month to Day, expanding detail within the same chart. Drillthrough navigates from one report page to a completely different detail page, filtered by the data point you right-clicked. Drilldown stays within one visual and expands a hierarchy. Drillthrough jumps between pages and provides contextual detail about a specific item like a product, customer, or region.
How do I set up drillthrough in Power BI?
To set up drillthrough: (1) Create a detail page in your report. (2) Drag the field you want to drill through on (such as Product Name or Customer ID) into the Drillthrough filters well on the Visualizations pane of the detail page. (3) Build your detail visuals on that page. (4) Power BI automatically adds a back button. Now users can right-click any data point on other pages that contains that field and select Drillthrough to navigate to the detail page, pre-filtered to the selected value.
How does cross-report drillthrough work in Power BI?
Cross-report drillthrough lets users right-click a data point in one Power BI report and navigate to a detail page in a completely different report, with filters applied. To enable it, turn on the "Allow cross-report drillthrough" toggle in the drillthrough target page settings. Both reports must be published to the same Power BI workspace. The target report's drillthrough fields must match the source data model fields. Cross-report drillthrough works in Power BI Service and is ideal for separating summary dashboards from detailed operational reports.
What does "Keep all filters" do in drillthrough?
The "Keep all filters" toggle on the drillthrough page controls whether existing page-level and report-level filters carry over when a user drills through. When enabled, the detail page inherits all active filters from the source page in addition to the drillthrough filter. When disabled, only the drillthrough filter applies. EPC Group recommends enabling "Keep all filters" for financial and operational reports where context like date range and department must persist, and disabling it for standalone detail pages that should show the complete picture for a selected item.
What are best practices for drillthrough and drilldown in enterprise Power BI?
Enterprise best practices include: (1) Use drilldown for time-based analysis and geographic hierarchies where users explore within one chart. (2) Use drillthrough for entity detail pages like customer profiles, product breakdowns, and regional deep dives. (3) Limit hierarchies to 4 levels maximum to prevent user confusion. (4) Always label drillthrough pages clearly with a naming convention like "Detail - [Entity]". (5) Test drillthrough with row-level security to confirm users only see authorized data on detail pages. (6) Add visual cues like info tooltips explaining right-click drillthrough availability. (7) Use bookmarks as an alternative navigation method for mobile users who cannot right-click.
Does drillthrough or drilldown impact Power BI report performance?
Drilldown has minimal performance impact because it queries the same dataset with an additional filter on the hierarchy level. Drillthrough has slightly more impact because it loads a new page with its own visuals and queries. For enterprise reports, EPC Group recommends keeping drillthrough detail pages under 8 visuals to maintain sub-second load times. Cross-report drillthrough adds latency because Power BI must load the target report. Use DirectQuery sparingly on drillthrough pages and prefer Import mode or composite models for detail pages that need fast response times.
Do drillthrough and drilldown work on Power BI mobile?
Drilldown works fully on Power BI mobile. Users tap the drill-down arrow icons in the visual header to navigate hierarchy levels. Drillthrough is supported on mobile but requires a long-press (tap and hold) on a data point to access the context menu, which is less discoverable than right-click on desktop. EPC Group recommends adding button-based navigation as an alternative to right-click drillthrough for reports primarily consumed on mobile devices. Use Power BI bookmarks with button actions to create explicit navigation links that work seamlessly on both desktop and mobile.
About Errin O'Connor
Founder & Chief AI Architect, EPC Group
Errin O'Connor is the founder and Chief AI Architect of EPC Group, bringing over 28 years of Microsoft ecosystem expertise. As a 4x Microsoft Press bestselling author including the definitive Power BI enterprise guide, and former NASA Lead Architect, Errin has designed drillthrough and drilldown navigation patterns for 200+ Fortune 500 Power BI deployments across healthcare, finance, and government sectors.
Learn more about Errin