How to Get Drill Through Option in Power BI

Power BI dashboards are great for high-level summaries, but the real insights often hide in the details. You've built a beautiful chart, but now you need to see the specific data points that make up a single bar or slice. This is where the drillthrough feature comes in, turning your static reports into interactive tools for deep analysis. This article will walk you through exactly how to set up and use the drillthrough option in Power BI to unlock deeper layers of your data.

Graphed

Still Building Reports Manually?

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

Watch the Demo

What Exactly Is a Drillthrough in Power BI?

A drillthrough is an action in Power BI that lets you navigate from a data point on one report page (the source) to another page (the destination) to see details specifically about that data point you selected. Think of it as creating a dedicated "detail" page for any piece of your summary data.

Imagine you have a bar chart showing total sales by country. The United States bar is the highest, and you want to know which product categories contributed to that specific total. Instead of creating a messy, crowded chart or a new report from scratch, you can simply right-click the "United States" bar, select "Drillthrough," and instantly see a new page pre-filtered to show only US sales broken down by product category, customer, and region.

This provides a clean, user-friendly way to offer your audience two levels of information:

• The big picture: A summary dashboard with key metrics.
• The focused details: Contextual, filtered data that explains what's behind the summary numbers.

Creating this functionality is a two-part process: first, you set up the destination "detail" page, and then you enable the action on your source visuals.

Setting Up Your First Drillthrough Page

The magic starts by creating the page you want to drill through to. This destination page will contain the charts, tables, and KPIs that provide the detailed view.

Graphed

Still Building Reports Manually?

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

Watch the Demo

Step 1: Create a New Destination Page

First, create a new page in your Power BI report. Give it a descriptive name, like "Sales Details by Country" or "Product Performance Drilldown." This page can be visible or hidden, many report creators hide their drillthrough pages by right-clicking the page tab and selecting "Hide Page." This keeps the report interface clean for end-users, as they will only access this page via the drillthrough action itself.

On this new page, build out the visuals you want to see. For our sales by country example, you might add:

• A bar chart showing sales by Product Category.
• A table showing the individual sales transactions.
• A card visual displaying the total number of orders.

Right now, this page shows data for all countries. The next step is what connects it to a specific country selected on your summary page.

Step 2: Add Your Drillthrough Field

This is the most critical step. To turn this regular report page into a drillthrough destination, you need to tell Power BI which data field will be used to filter it.

With your destination page selected, go to the Visualizations pane on the right. Look at the empty space below the visual options where you find settings for Page information and Canvas settings. Drag the field you want to filter by from the Data pane into the Drillthrough well at the bottom of this section.

In our example, you would drag the "Country" field into this box. As soon as you add a field here, two things happen:

• Power BI automatically adds a "Back" button icon to the top-left corner of your report page.
• A "Keep all filters" toggle appears under your drillthrough field.

Step 3: Understanding "Keep All Filters"

The "Keep all filters" option is powerful. By default, it's turned on.

• Turned ON (Default): When a user drills through, Power BI will apply the filter from the data point they clicked (e.g., Country = "United States") and it will also pass along any other active filters from the source page. For instance, if the source page was already filtered to the year 2023 and the "Electronics" department, both of those filters will also be applied to your drillthrough page. This is usually what you want.
• Turned OFF: If you turn this off, Power BI will only apply the filter from the specific data point clicked (e.g., Country = "United States") and ignore all other slicers or filters active on the source page. This is less common but useful if you want the drillthrough page to be a completely clean slate apart from the main context.

For most scenarios, leaving "Keep all filters" ON provides the most intuitive user experience.

Graphed

Still Building Reports Manually?

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

Watch the Demo

Using the Drillthrough Option on Your Report

Now that your destination page is configured, using it is incredibly simple. Navigate back to your main summary page (the source page).

Find the visual that contains the drillthrough field - in our case, the bar chart showing sales by "Country". To activate the drillthrough:

1. Hover over the data point you want more details on (e.g., the bar for "Canada").
2. Right-click the data point.
3. In the context menu that appears, you will now see an option named Drillthrough.
4. Hover over it, and another menu will pop up showing a list of available destination pages. Select your "Sales Details by Country" page.

Power BI will immediately take you to that page, which is now filtered to show data only for Canada. You can see the detailed product category breakdown, sales transactions, and order counts - exclusively for Canada. To return, simply click the Back button Power BI added.

What if the Drillthrough Option Isn't Showing Up?

If you right-click and don't see the drillthrough option, it's usually for one of these reasons:

• You didn't select a data point: Make sure you right-click on an actual bar, slice, point, or row representing the data, not just the blank background of the visual.
• Mismatched fields: The visual you clicked on must contain the exact same field you placed in the Drillthrough well on the destination page (e.g., the "Country" field).
• The page setup is incomplete: Double-check that you've successfully dragged a field into the drillthrough well on your destination page. Without a field there, Power BI has no idea that the page is meant for drilling through.

Advanced Tips for Better Drillthroughs

Once you've mastered the basics, you can enhance your reports even further with a few advanced techniques.

Using a Measure for Drillthrough

You’re not limited to just categorical text fields like "Country" or "Product". You can also add a measure (like "Total Sales") to the drillthrough well. This is useful when you want to see the underlying components of a single KPI value.

For example, if you have a summary table showing "Total Sales" by month, you could add the "[Total Sales]" measure to a drillthrough destination page's filter well. When a user right-clicks on the sales value for May ($150,000), they can drill through to see a list of every single transaction that contributed to that specific $150,000 total.

Cross-Report Drillthrough

Drillthrough isn't limited to pages within a single report. You can set it up to navigate between completely separate reports, as long as they reside in the same Power BI workspace. This helps you build a cohesive, interconnected suite of reports where your "Sales" report can drill into details found in your "Inventory" report.

To enable this, head to File -> Options and settings -> Options. Under the "Current file" section, go to "Report settings" and check the box that says, "Allow visuals in this report to use drillthrough targets from other reports." Once enabled for both the source and target reports, the setup process works identically.

Graphed

Still Building Reports Manually?

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

Watch the Demo

Customizing the Back Button

The standard back button works, but you can make it more informative. You can replace the icon with custom text that dynamically updates based on the drillthrough filter. Instead of a generic arrow, imagine a button that says "Back to Sales for the US" or "Return to Product Dashboard."

To do this, you create a measure using DAX that combines text with the selected value of your drillthrough field, like so:

BackButtonText = "Back to Details for " & SELECTEDVALUE('Sales'[Country])

Then, click on the back button, go to its formatting options, find the Button Text property, and use the fx button to set its value based on your new BackButtonText measure. It's a small touch that greatly improves the polish and usability of your reports.

Final Thoughts

The drillthrough feature is a fundamental building block for creating premium interactive reports in Power BI. By creating dedicated detail pages and linking them with a common field, you empower your users to move beyond surface-level summaries and explore the "why" behind the numbers on their own terms.

This process of building layered reports works beautifully, but it does require some planning and setup. For marketing and sales teams who often need answers fast without navigating setup panes and schemas, we built Graphed to simplify this process. Instead of creating and linking pages manually, you can just ask a follow-up question in plain English. After seeing your sales by country, you could simply ask, "show me top product categories just for the United States," and instantly get the answer without switching contexts or building a new report page. It's about getting those same deep insights in a few seconds, not a few minutes.