How to Add a Drill Through in Power BI

You built a Power BI report. It looks great. But the moment someone asks, “Can I see the breakdown behind this number?” — you’re stuck.

That’s exactly the problem drill through solves.

Drill through lets your audience right-click any data point and land on a fully filtered detail page — in seconds. No extra slicers. No manual filtering. No back-and-forth.

Power BI is used by over 250,000 organisations worldwide, and it holds roughly 36% market share among business intelligence tools. Yet most people only scratch the surface of what it can do. Drill through is one of the most powerful — and most underused — features in the entire platform.

This guide walks you through every step to add drill through in Power BI, configure it properly, and make it work reliably across your reports.

What Is Drill Through in Power BI?

Drill through is a navigation feature that lets report viewers click on a data point and jump to a dedicated detail page — pre-filtered to show only the relevant context.

Think of it this way: you have a summary page showing total sales by region. A stakeholder wants to dig into the Southeast numbers specifically. With drill through, they right-click the Southeast bar, select “Drill through,” and instantly land on a page showing only Southeast data — customers, products, reps, dates — everything filtered automatically.

The key difference from basic filtering is context preservation. The destination page knows exactly what the user clicked, and it responds accordingly.

According to research from Nucleus Research, analytics tools that enable self-service data exploration reduce the time to insight by up to 70%. Drill through is a core part of making Power BI self-service.

Why Drill Through Changes How People Use Your Reports

Most Power BI reports are built for display, not exploration. Drill through flips that.

When users can explore data themselves — without needing a new report or asking the analyst to filter things manually — engagement with the report increases dramatically. A Gartner study found that organisations with self-service analytics capabilities are 1.5x more likely to make faster business decisions than those relying on centralised report requests.

Drill through specifically helps when:

• You have summary-level dashboards that feed into operational detail
• Different audience types need different depths of information from the same dataset
• You want to keep top-level visuals clean without cramming in every dimension
• You need stakeholders to explore freely without breaking the report structure

It’s not just a feature — it’s a UX decision that determines whether your report gets used or ignored.

How to Add a Drill Through in Power BI (Step by Step)

Here’s the exact process to get drill through working in your Power BI report.

Open Power BI Desktop and Prepare Your Report

Before you add drill through, you need at least two pages in your report:

• A summary page where users will initiate the drill through action
• A detail page where users will land after drilling through

If you don’t have both yet, add a blank page from the Pages panel on the left side of Power BI Desktop.

Create Your Detail Page

The detail page is where the drill through lands. Design it with the specific data you want to expose — the granular breakdown that doesn’t fit on the summary page.

This page should typically include:

• A table or matrix showing row-level data
• Cards for key metrics
• Visuals that make sense in a filtered, single-entity context

Name the page clearly. Something like “Customer Detail” or “Product Breakdown” is better than “Page 2.” This name appears in the right-click menu when users drill through, so clarity matters.

Add a Drill Through Filter Field

This is the critical step most people miss.

On your detail page, look at the Visualizations pane. Scroll down to the Drill through section — it appears below the Filters pane on the right side of the screen.

Drag the field you want to use as the drill through anchor into the “Add drill-through fields here” well. This field is what connects the summary page to the detail page.

For example:

• If users will drill through by Customer Name, drag the Customer Name field here
• If users will drill through by Product Category, drag Product Category here
• If users will drill through by Region, drag Region here

Once you drop a field into this well, Power BI automatically adds a back button to your detail page so users can navigate back to where they came from.

Configure the Back Button (Optional but Recommended)

Power BI generates a default back button automatically when you set a drill through field. However, you can customise it:

• Select the back button on the detail page
• Use the Format pane to change its style, colour, and size
• Reposition it to a prominent, consistent location — top left is the standard

You can also delete the auto-generated button and create your own using Insert > Buttons > Back if you prefer a custom design.

Test the Drill Through on Your Summary Page

Go back to your summary page. Right-click on any data point that contains your drill through field — a bar, a row in a table, a map bubble, anything.

You should see a “Drill through” submenu appear in the context menu. Hover over it, and your detail page name appears as an option. Click it.

If everything is configured correctly, your detail page loads — filtered to the exact data point you right-clicked.

If the option doesn’t appear, check that:

• The drill through field on the detail page matches the field being used in the visual you’re clicking
• The visual you’re clicking actually contains that field (check its field wells)
• You’re right-clicking on a data value, not on empty chart space

Publish and Verify in Power BI Service

Once drill through works in Power BI Desktop, publish your report to Power BI Service (app.powerbi.com).

Test the drill through again in the browser. The behaviour should be identical — right-click, select “Drill through,” land on the detail page filtered correctly.

According to Microsoft’s Power BI documentation, drill through works the same way in both Desktop and Service, but always verify after publishing since workspace and dataset permission settings can occasionally affect interactive features.

Drill Through vs Drill Down in Power BI

These two features are easy to confuse, but they do different things.

Drill down expands a hierarchy within the same visual on the same page. If you have a bar chart grouped by Year > Quarter > Month, drilling down moves you from Year bars to Quarter bars to Month bars — all within that one chart.

Drill through navigates you to a completely different page in the report, filtered to the context of what you clicked.

Use drill down when you want to explore different levels of the same dimension. Use drill through when you want to expose more data — different metrics, different visuals — specific to what the user selected.

Many advanced Power BI reports use both together. A user drills down through a time hierarchy to find the problematic month, then drills through to a detail page showing the underlying transactions for that month.

How to Enable Cross-Report Drill Through

Standard drill through works within a single report. But Power BI also supports cross-report drill through — navigating from one report to a detail page in a completely different report.

To enable it:

In the target report (the one with the detail page), go to the detail page and add the drill through field as normal. Then, in the Options menu (File > Options and Settings > Options > Current File > Report settings), check “Allow visuals in this report to use drill-through targets from other reports.”

In the source report (where users initiate the drill through), the same setting must be enabled.

Both reports must be in the same Power BI workspace for cross-report drill through to function.

This feature is particularly useful in large organisations where one team owns summary dashboards and another owns operational detail reports.

Advanced: Using Measures and What-If Parameters with Drill Through

By default, drill through passes a field value as a filter. But you can also pass measures into drill through pages to make them more dynamic.

When you drop a measure into the drill through field well instead of a dimension, Power BI passes the measure context — not a filter — to the detail page. This allows drill through pages to respond to calculated values, not just categorical fields.

This is an advanced technique that requires careful data model design, but it significantly expands what drill through pages can display.

Keep in mind: According to a 2024 survey by BARC Research, only 42% of Power BI users actively use cross-filtering and drill features beyond basic slicers. That means most report consumers are missing out on deeper analysis — which is a design problem, not a user problem. Building intuitive drill through paths directly into your report eliminates the friction.

Common Drill Through Mistakes (and How to Fix Them)

The drill through option doesn’t show up. The most common cause is a field mismatch. The field in your visual must be the same field (or directly related) to the field in the drill through well on your detail page. Check both.

The detail page shows all data instead of filtered data. This means the drill through field isn’t connected correctly. Re-check that you dropped the field into the “Add drill-through fields here” section specifically, not into the page-level Filters well.

The back button navigates to the wrong page. If you have multiple summary pages, the back button always returns to whichever page the user drilled from. This is correct behaviour — you can’t control which page it goes back to, but you can add multiple navigation buttons to give users more options.

Drill through doesn’t work after publishing. Verify that Row Level Security (RLS) isn’t blocking the detail page for certain users, and that the dataset refresh hasn’t broken any field relationships.

Power BI Drill Through: Key Statistics

Data exploration is no longer optional for competitive organisations. Here’s the scale of what Power BI and analytics capabilities mean in practice:

• Power BI is used in over 250,000 organisations and by more than 5 million users worldwide (Microsoft, 2024)
• Organisations that adopt self-service BI tools see a 28% improvement in decision-making speed (Dresner Advisory Services)
• 97.2% of organisations say they are investing in big data and AI capabilities — interactive reports are a core delivery layer (NewVantage Partners)
• Companies using data visualisation tools are 43% more likely to make faster decisions than those relying on static reports (Nucleus Research)
• 70% of business users say they need easier ways to access detailed data without going through IT (Gartner)
• Reports with interactive navigation features like drill through see up to 3x more engagement compared to static dashboards (Tableau Research, 2023)

These numbers point to one clear reality: the teams that build interactive, explorable reports are the ones whose work actually gets used.

Tips for Better Drill Through Pages

Keep the detail page focused. A drill through page that tries to show everything is just as confusing as no drill through at all. Decide on the two or three most valuable things a user needs to see when they drill, and show only those.

Label your detail pages clearly. The page name appears in the right-click menu. “Sales Detail – By Product” is actionable. “Page 5” is not.

Use consistent formatting. Your detail page should feel like it belongs to the same report — matching fonts, colours, and layout principles. Jarring visual changes break the user experience.

Add context to the detail page. Include a card or title that shows what the page is filtered to — for example, “Showing results for: [Customer Name]”. Users should never have to wonder why they’re seeing what they’re seeing.

Test on the smallest screen your audience uses. Drill through pages often have more dense data than summary pages. Make sure they’re readable on laptops, not just desktop monitors.

Conclusion

Drill through is one of the features that separates a functional Power BI report from a genuinely useful one.

Once it’s set up, the people reading your reports stop being passive consumers and start exploring data on their own terms. They get the summary view and the detail — without needing a separate report, a new meeting, or an analyst to filter things for them.

The setup takes minutes. The impact on how your reports get used is lasting.

Start with one summary page and one detail page. Add a single drill through field. Test it. Then build from there.

The difference between a report that sits untouched and one that drives decisions often comes down to exactly this kind of interactive design.