How to Create a Drillthrough Report in Power BI

Power BI drillthrough reports transform a static dashboard into an interactive, multi-layered analytical experience. Instead of just presenting a high-level summary, this feature lets your users click on a specific data point and instantly 'drill through' to a separate, more detailed page filtered just for that information. This article walks you through exactly how to set up drillthrough reports in Power BI, step by step.

Graphed

Your AI Data Analyst to Create Live Dashboards

Connect your data sources and let AI build beautiful, real-time dashboards for you in seconds.

Build Your First Dashboard

What Exactly is Drillthrough in Power BI?

Think of drillthrough as creating a contextual link between your report pages. On one page, you have a summary visual, like a bar chart showing total sales by country. When a user sees something interesting - say, sales for Germany are unusually high - they can right-click the "Germany" bar and jump to a pre-designed "Country Details" page. That destination page will then be automatically filtered to show data only for Germany.

This allows you to build clean, high-level dashboards while still providing access to the granular data that lives just a click away. It's an elegant way to guide users from a "what" question (What were our sales by country?) to a "why" question (Why are Germany's sales so high?) without cluttering a single screen.

The main benefits of using drillthrough are:

• Reduced Clutter: It keeps your main dashboard clean and focused on key performance indicators (KPIs), tucking the detailed tables and charts away on secondary pages.
• Guided Analysis: You create a clear and intuitive path for users to explore the data, leading them from summary to detail in a logical flow.
• Enhanced User Experience: Instead of applying multiple manual filters, users can get to the details they need with a single right-click, which feels natural and efficient.
• Improved Performance: Loading a summary page with fewer visuals is faster than loading one massive, overloaded page with every possible detail.

Getting Started: Your Report's Foundation

Before you can implement the drillthrough feature, your Power BI report needs a specific structure. At a minimum, you must have two distinct pages:

1. A Source Page: This is your main dashboard or summary report. It contains the high-level visuals that users will interact with first, like a pie chart of market share or a map showing regional performance.
2. A Destination Page: This is the detailed report page. It’s where users will land after they drill through. This page should contain visuals that provide deeper context on the drillthrough field, such as a detailed data table, trend lines, or specific KPIs.

For example, your source page might have a bar chart of "Revenue by Sales Rep," and your destination page might be a "Sales Rep Performance" dashboard showing that rep's deals, conversion rates, and sales activity over time. The key is that the detail page is designed to be viewed in the context of a single filter - in this case, a single sales rep.

AI for Data Analysis

Crash Course

Graphed

Free PDF Guide

AI for Data Analysis Crash Course

Learn how to get AI to do data analysis for you — the best tools, prompts, and workflows to go from raw data to insights without writing a single line of code.

Download Free Guide

How to Set Up a Drillthrough in Power BI: A Step-by-Step Guide

Setting up drillthrough is surprisingly straightforward. Once you have your source and destination pages ready, the actual configuration only takes a minute. Let’s walk through the process using a common business scenario: analyzing sales data by product category.

Our goal: Allow users to right-click a product category on a summary chart and jump to a detailed page showing sales metrics specifically for that category.

Step 1: Create and Design Your Destination Page

First, build the page that will serve as your drillthrough target. This is the "detail" view. For our example, we'll call this page "Product Details."

On this page, add visuals that would be valuable for analyzing a single product category. You might include:

• A card showing Total Sales for the category.
• A card showing Total Units Sold.
• A line chart illustrating sales trends over time for that category.
• A table listing individual products within the category, along with their sales figures.

Don't worry about filtering this page manually. The drillthrough action will handle that automatically. Just design it as if you were looking at one category at a time.

By default, Power BI destination pages are hidden from report viewers, so a user won't accidentally navigate to an unfiltered and confusing detail page. They can only access it via the drillthrough action you are about to create.

Step 2: Assign the Drillthrough Field

This is the most important step. You need to tell Power BI which field will be used to connect the source and destination pages.

1. Make sure your "Product Details" (destination) page is selected.
2. With no visuals selected on the canvas, look at the Visualizations pane on the right-hand side.
3. At the bottom of this pane, you'll see a section under Page information called Drill through.
4. From your Data pane, find the field you want to filter by. In our case, this is Product Category. Drag Product Category from the Data pane and drop it into the "Add drill-through fields here" well.

That's it! As soon as you add that field, Power BI takes care of two things:

• It designates this page as a drillthrough target that can receive a Product Category filter.
• It automatically adds a "Back" button icon to the top-left of your report canvas. This pre-configured button will take users back to the page they came from with a single click.

Graphed

Your AI Data Analyst to Create Live Dashboards

Connect your data sources and let AI build beautiful, real-time dashboards for you in seconds.

Build Your First Dashboard

Step 3: Test Your Drillthrough Action

Now it's time to see your work in action. Navigate back to your Source Page - the one containing the summary-level visual.

1. Find a visual that uses the Product Category field. This could be a bar chart showing "Sales by Product Category" or a pie chart.
2. In Power BI Desktop, hold Ctrl and right-click on a single data point (e.g., the bar for the "Computers" category). If you're in the Power BI Service (online), you can just right-click.
3. A context menu will appear. You should now see a Drill through option. Hover over it.
4. Select your destination page, "Product Details," from the submenu.

Power BI will immediately navigate you to the "Product Details" page. You'll notice that every visual on that page is now filtered to show data only for the "Computers" category. You can use the back button in the top-left corner to return to your source page and explore another category.

Advanced Drillthrough Techniques for a Better User Experience

Once you've mastered the basics, you can enhance your reports with a few more advanced drillthrough features.

Tip 1: Using the "Keep All Filters" Option

In the "Drill through" setup pane on your destination page, you'll see a toggle for Keep all filters. This small feature has a big impact.

• When OFF (the default), only the filter from the specific data point you clicked is passed to the destination page.
• When ON, Power BI passes the drillthrough filter and any other active filters on the source page (from slicers or cross-filtering from other visuals).

In most cases, you’ll want to turn this ON. Imagine your source page has a year slicer set to "2023." If a user drills through on the "Bikes" category, they expect the detail page to show data for "Bikes" and "2023." Leaving this option off would ignore the year filter, which could be confusing. Turning it on ensures a consistent analytical context between pages.

Tip 2: Creating a Custom Drillthrough Button

While the right-click menu works fine, it isn't always obvious to new users. For a more professional and intuitive user experience, you can create an explicit button that performs the drillthrough action.

1. On your Source Page, go to the Insert tab on the ribbon and add a Button (a blank one is often best).
2. Select the new button and go to the Format pane for it.
3. Expand the Action section and turn it ON.
4. For the Type, select Drill through.
5. For the Destination, select your target page ("Product Details").

The magic of this button is its state. By default, it will be grayed out and disabled. It only becomes active when a user selects a single valid data point on a visual that contains the drillthrough field (e.g., when they click on the single "Computers" bar). This gives a clear visual cue that an action is available. You can even update the button text to dynamically show what they've selected, like "See details for [Selected Category Name]."

AI for Data Analysis

Crash Course

Graphed

Free PDF Guide

AI for Data Analysis Crash Course

Learn how to get AI to do data analysis for you — the best tools, prompts, and workflows to go from raw data to insights without writing a single line of code.

Download Free Guide

Tip 3: Setting Up Cross-Report Drillthrough

For even more advanced scenarios, Power BI allows you to drill through from one report to another. This is incredibly useful for organizations that want to maintain separate "Executive Summary" and "Operational Detail" reports.

The setup is identical to a standard drillthrough, with one extra step. In the "Drill through" setup pane of the destination report, you simply need to turn on the Cross-report toggle. Both reports must be published to the same workspace in the Power BI Service for this to work. It’s a powerful way to connect a larger ecosystem of reports without having everything in a single, massive .PBIX file.

Final Thoughts

Mastering the drillthrough feature is a non-negotiable skill for anyone serious about building professional, user-friendly reports in Power BI. It allows you to move beyond flat, single-page dashboards and create a rich, guided data exploration story for your end-users, giving them summary insights and detailed answers all in one place.

This process of going from summary to detail, from the "what" to a "why," is the core of effective data analysis. While powerful tools like Power BI give you the building blocks, it still requires manual configuration to build these intuitive flows. At Graphed, we accelerate this discovery process by letting you dive deeper into your data using plain English. After seeing a summary chart of your marketing data, you can simply ask a follow-up question like, "why did traffic from the USA drop last week?" to instantly get the specific details you need, without needing to pre-configure a drillthrough page.