How to Turn On Drill Through in Power BI

Drill through is one of the most powerful and user-friendly features in Power BI, letting you turn a high-level dashboard into an interactive, multi-layered report. This feature allows you to create a focused view of your data by navigating from a general summary chart to a detailed breakdown page. We will walk you through exactly how to enable and use the drill-through experience to make your reports more dynamic and insightful.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

What Exactly is Drill Through in Power BI?

Imagine you have a bar chart showing total sales by country. You notice that the United States has the highest sales, and you want to know which product categories are driving that performance. Without drill through, you might have to go to a separate "Sales Details" page and manually apply a filter for "United States".

Drill through automates this process. It lets you right-click the "United States" bar on your main chart and jump directly to a pre-designed detail page that is automatically filtered to only show data for the United States. It creates a seamless and intuitive path for users to explore the 'why' behind the numbers.

Key Concepts to Understand

The drill-through feature involves two main components in your Power BI report:

• Source Page: This is the starting page containing the primary, high-level visual. For example, a "Sales Overview" dashboard with a pie chart showing revenue by region.
• Target Page: This is the destination page that contains the granular details. For instance, a "Regional Details" page with a data table showing sales by city, customer, and product.

When a user initiates the drill through on the source page (e.g., by clicking on the 'North America' slice of the pie chart), Power BI passes that 'North America' context as a filter to the target page, showing only the associated detailed data.

Why Should You Use Drill Through?

Before jumping into the setup, it's helpful to understand the value it adds. Turning on drill through doesn't just add a neat trick to your report, it fundamentally improves the user experience and the analytical power of your dashboard.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

1. It Keeps Your Dashboards Clean

Executive dashboards should provide a clear, at-a-glance summary. Cramming too many details, tables, and slicers onto one page creates clutter and confusion. Drill through lets you maintain a clean, high-level view on your main page while making granular data easily accessible just one click away.

2. It Provides Context-Specific Insights

The biggest benefit is the automatic filtering. Users don't need to hunt for the right slicer or filter on a crowded detail page. They get a focused view of the data that is directly related to the specific data point they were curious about. This makes the exploration process natural and efficient.

3. It Encourages Self-Service Data Discovery

Drill through empowers business users to answer their own follow-up questions. When they see an interesting number on a summary chart, they don't have to email a data analyst for a new report. They can simply drill through to explore the underlying drivers themselves, fostering a more data-driven culture.

4. It Improves Report Presentation

When presenting your findings, drill through allows you to guide your audience through a data story. You can start with the big picture and seamlessly dive into specifics to support your narrative, all without awkwardly switching between different reports or pages.

Step-by-Step Guide: How to Turn on Drill Through

Setting up drill through is surprisingly simple. You just have to tell Power BI which page is the destination (the target page) and what field connects it to the source page. Let's walk through it with a sales report example.

For this walkthrough, assume you have two pages:

• An 'Overview' page with a bar chart showing Sales by Region.
• A 'Region Details' page with a map and a table of sales broken down by city.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

Step 1: Design Your Target Page

First, build the page your users will drill through to. This is your 'Region Details' page. The visuals here should provide the next layer of detail your users would want to see. For example, if your summary visual shows sales by region, your detail visuals could show:

• A table listing sales values by city within that region.
• A map visual pinpointing sales locations.
• A bar chart showing the top salespeople for that region.

Think about the questions your source chart creates. If a user sees sales are high in the "West" region, their next question is probably "Which cities in the West are performing best?" Design your target page to answer that question.

Step 2: Add the Drill-through Field

This is where you officially "turn on" the drill through functionality for the page.

1. On your target page (our 'Region Details' page), make sure no visuals are selected by clicking on the blank canvas.
2. Go to the Visualizations pane on the right-hand side.
3. Look for the section at the bottom labeled Drill through. You may need to scroll down in the "Page information" card.
4. From your Data pane, find the field that connects your source and target pages. In our example, this is the Region field.
5. Drag the Region field into the "Add drill-through fields here" box.

Once you drop the field in, two things will happen:

• The "Keep all filters" toggle will be on by default. This is usually what you want, as it ensures any other filters active on the source page (like a date slicer) are also passed to the target page.
• Power BI will automatically add a small "back" button to the top left of your report page. This button lets users easily return to their original source page after reviewing the details.

Step 3: Test It From Your Source Page

Now for the fun part. Navigate back to your source page (the 'Overview' page) where you have the 'Sales by Region' bar chart.

1. Find the visual that contains the drill-through field (your bar chart has 'Region' on its axis).
2. Move your mouse over a data point and right-click it. For example, right-click the bar for the "West" region.
3. In the context menu that appears, you will now see an option for Drill through.
4. Hover over it, and a flyout menu will show the name of your target page: 'Region Details'.
5. Click on 'Region Details'.

You will be transported to the detail page, and all the visuals on that page will be filtered to show data for the "West" region only. You did it! The drill through is now active.

Tips and Best Practices for a Great User Experience

Setting up drill through is easy, but making it intuitive and effective requires a bit of thought. Here are a few tips to enhance the experience.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

Create a Drill-through Button for Clarity

The right-click menu works fine, but it’s not always obvious to new users. You can create an explicit "button" for a clearer call to action.

1. On your source page, go to the Insert tab, select Buttons, and choose Blank.
2. Style the button as you wish (add text like "See Region Details", change colors, etc.).
3. With the button selected, go to the Format pane and expand the Action section.
4. Turn the Action On. For Type, select Drill through. For Destination, select your target page ('Region Details').

By default, the button will be disabled. It will only become clickable after a user selects a value in a compatible visual (e.g., clicks on one of the region bars). This behavior is actually a great feature - it guides the user to select a data point first.

Use Smart Page Naming

Name your target page clearly. Instead of 'Page 2', name it 'Sales Details by SKU' or 'Campaign Performance Breakdown'. The page name appears in the right-click menu, so a descriptive name tells the user exactly where they are going.

"Cross-report" Drill Through

You can even set up drill through to work across different reports within the same Power BI workspace. The setup is nearly identical, you just need to enable the "Cross-report" toggle in the drill-through field well on your target page. This allows you to build a master summary report that can link to more specialized, detailed reports.

Final Thoughts

Mastering the drill-through feature is a simple yet high-impact way to elevate your Power BI reports from static charts to interactive analytical tools. It cleans up your dashboards, empowers users to explore data independently, and helps you tell a more compelling data story.

Ultimately, the goal of any reporting tool is to get valuable insights into the hands of decision-makers as quickly as possible. We built Graphed because we believe the process of exploring data and asking follow-up questions shouldn't require manual report building. Instead of spending time configuring pages, buttons, and drill-through paths, you can simply connect your data and ask questions like "what were my top sales cities in the West last month?" in plain English. Graphed handles the "drilling down" for you, turning hours of analysis into a simple, 30-second conversation.