How to Use Drill Through Button in Power BI

Moving from a high-level summary to a granular, detailed view is a core part of any good data analysis. In Power BI, the drillthrough feature lets you do just that, creating guided, interactive pathways through your reports. This article will walk you through setting up a dedicated detail page and creating a user-friendly drillthrough button that makes navigating your data intuitive and seamless.

Graphed

Still Building Reports Manually?

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

Watch the Demo

What Exactly is Drillthrough in Power BI?

Think of drillthrough as creating a link between a summary report page and a detail page. A user can look at a chart on your main sales dashboard, right-click a specific data point - like a bar representing "Canada" - and jump to a new page that shows a detailed breakdown of sales data filtered only for Canada.

This creates a focused view of a specific slice of your data without the user having to manually apply filters themselves. It turns your report from a static collection of charts into an exploratory tool. The whole process relies on two components:

• The Source Page: This is your high-level dashboard or summary report where the user starts their journey. It contains charts and tables with aggregate data (e.g., total sales by country).
• The Destination Page: This is the detail page. It's designed to show in-depth information about a single entity you've defined (e.g., detailed sales metrics for one specific country).

While you can use drillthrough with a simple right-click, adding a dedicated button provides a much clearer, more intuitive experience for your end-users, guiding them on exactly how to interact with the report.

Step 1: Set Up Your Drillthrough Destination Page

Before you can create a button to drill through, you need to build the page you're going to drill through to. This destination page serves as the template for your detailed view.

Follow these steps to prepare your destination page:

First, create a new page in your Power BI report. Give it a descriptive name like "Country Detail" or "Sales Rep Performance." This page will house the specific information you want a user to see when they drill down.

Add Your Detailed Visuals

Populate this page with the visuals that provide a granular view. For a "Country Detail" page, this might include:

• A map zeroed in on that country.
• A line chart showing sales trends over time just for that country.
• A table listing top products sold within that country.
• KPI cards for key metrics like Total Revenue, Units Sold, and Average Order Value.

Graphed

Still Building Reports Manually?

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

Watch the Demo

Enable the Drillthrough Functionality

This is the most critical step. With nothing selected on your canvas (click the blank space), look at the Visualizations pane. You'll see an area near the bottom labeled "Drill through."

Drag the field that will act as your filter into this box. For our example, we would find the Country field from our sales data table and drag it into the "Drill through" well.

Once you add a field here, two things happen automatically:

1. A small "back" button appears in the top-left corner of your report. This allows users to easily navigate back to the page they came from.
2. Power BI now knows that this page can be used as a drillthrough destination, and the context will be filtered by the Country field.

You can also toggle the "Keep all filters" option on. By default, it's off. If you turn it on, any filters applied on the source page (like a date range or product category) will be carried over to the destination page in addition to the drillthrough filter.

Step 2: Understand the Default Right-Click Drillthrough

With the destination page configured, the basic drillthrough functionality is already active. Go to your source page - the high-level sales dashboard.

Find a visual that uses the Country field, like a bar chart showing sales by country. Right-click on one of the bars, for example, the bar for the "United States." A context menu will appear, and you should see an option labeled "Drill through" with your destination page "Country Detail" listed underneath it.

When you click it, you’ll be taken to the "Country Detail" page, and all the visuals on that page will be automatically filtered to show data only for the "United States." It’s a powerful feature, but expecting your users to know they need to right-click is not always ideal. A button provides a much better signpost for action.

Step 3: Create a Dynamic Drillthrough Button

Now for the main event: adding a button that makes this whole interaction obvious and easy. This button will remain inactive until a user selects a value to drill down on.

Here’s how to set it up:

Graphed

Still Building Reports Manually?

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

Watch the Demo

1. Add a Button to the Source Page

Navigate back to your source page (the main sales dashboard). Go to the "Insert" tab on the ribbon, click "Buttons," and choose "Blank." Place the new button somewhere logical on your report canvas, perhaps next to the chart you intend for users to interact with.

2. Configure the Button Action

Select your newly added button. In the "Format" pane on the right, you’ll see several options for customizing it.

• Find the Action section and toggle it to "On."
• From the Type dropdown menu, select "Drill through."
• In the Destination dropdown that appears, choose the detail page you configured earlier, "Country Detail."

You'll notice the button is now grayed out and disabled. This is the intended behavior! The button will only become active and clickable once a user selects a single country from a visual on the report. For example, if they click the "United States" bar in your chart, the button will instantly become active and ready for use.

Step 4: Go Pro by Customizing Your Button UX

A functional button is good, but a smart, communicative button is even better. You can use a bit of DAX to make the button text and tooltips dynamic, providing a truly high-quality user experience.

Create Dynamic Button Text

Instead of a generic label like "See Details," you can make the button text update to reflect the user's selection.

• With the button selected, go to the "Style" section in the Format pane and open the "Text" options.
• Instead of typing static text into the text box, click the little fx button to the right of it. This opens the conditional formatting editor.
• In the formula bar at the top, enter a simple measure that changes based on the selection. A classic approach is to use the SELECTEDVALUE function. For our example, you could write:

"Drill through to " & SELECTEDVALUE('Sales'[Country], "a Region")

This formula tells Power BI: "Display the text 'Drill through to ' followed by the selected country name. If no single country is selected, display 'Drill through to a Region' instead." Now, when a user clicks on "Germany," your button immediately changes to say "Drill through to Germany."

Graphed

Still Building Reports Manually?

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

Watch the Demo

Provide Instructions with Dynamic Tooltips

The "Tooltip" property is a fantastic way to guide your users. A static tooltip could say, "Select a country to enable this button." But you can make it dynamic here as well.

• In the button's "Action" settings, you’ll find the Tooltip text box. Click the fx button next to it.
• Here, you can use an IF statement to deliver a different tooltip depending on the button's state.

IF(
    HASONEVALUE('Sales'[Country]),
    "Click to see a detailed report for " & SELECTEDVALUE('Sales'[Country]),
    "Please select a single country in the chart above to view details."
)

With this formula, if nothing is selected, hovering over the disabled button shows a helpful instruction. Once a country is selected, the tooltip confirms what will happen when they click.

Customize Button States

Finally, you can customize how the button looks in its different states (Default, On hover, Disabled). In the Format pane, you can adjust the appearance for each state.

For example, you can make the "Disabled" state have a lighter, semi-transparent fill color and gray text to make it visually clear that it's not currently clickable. This helps prevent user confusion and makes your report feel more like a professional application.

Final Thoughts

By pairing the powerful drillthrough feature with well-designed buttons, you can transform a typical Power BI report into a guided, exploratory experience for your users. It moves your dashboards beyond just displaying data and into the realm of answering questions, allowing stakeholders to self-serve insights by seamlessly navigating from the big picture to the details that matter.

Building interactive reports in business intelligence tools can feel complicated, especially when you're just trying to get quick answers from your data. The truth is you don’t need to spend hours learning complex tools just to see your key marketing or sales metrics. Instead of clicking through menus and configuration panes, we created a way for you to just ask for what you want in plain English. With Graphed , you simply connect your data sources - like Google Analytics, Shopify, or Salesforce - and describe the dashboard you need. It's built for you in seconds, with real-time data, letting you get back to analyzing instead of configuring.