How to Clear Drillthrough in Power BI

Power BI's drillthrough feature is fantastic for deep analysis, letting you jump from a high-level summary to a detailed breakdown in a single click. But you may have noticed an annoying quirk: sometimes, that drillthrough filter sticks around, following you through your report when you didn't want it to. This article will show you exactly how to clear drillthrough filters so you can navigate your reports smoothly.

Graphed

Build AI Agents for Marketing

Build virtual employees that run your go to market. Connect your data sources, deploy autonomous agents, and grow your company.

Build Your First Agent

What is Drillthrough and Why is it Useful?

First, a quick refresher. In Power BI, drillthrough connects pages in your report. You can set up a "main" page with summary visuals (like total sales by country) and a "detail" page with more granular information (like sales by city or individual transaction data).

When you right-click on a data point in your summary chart - say, "United Kingdom" - you can "drill through" to the detail page. That detail page will then be automatically filtered to show only data for the United Kingdom. It’s an incredibly intuitive way to let users explore the data behind the headlines.

It's the digital equivalent of asking, "Okay, the UK is our top market. Show me the specific sales that make up that number." This makes your reports interactive and empowers your team to find answers on their own without needing a new report for every question.

AI Agents for Marketing

Crash Course

Graphed

Free PDF · the crash course

AI Agents for Marketing Crash Course

Learn how to deploy AI marketing agents across your go-to-market — the best tools, prompts, and workflows to turn your data into autonomous execution without writing code.

Download the PDF

The "Sticky Filter" Problem in Power BI

The problem arises in how Power BI handles this filter. When you drill through, Power BI applies a filter to the detail page based on your selection. By design, this filter is "sticky." If you navigate away from that detail page by clicking on another report tab, Power BI assumes you want to keep that filter context.

For example, you drill through from your "Sales Summary" page to your "Deal Details" page to look at the UK. You spend a few minutes there, then click on your "Marketing Performance" tab. You might be surprised to see that your marketing visuals are now also filtered for the UK. The drillthrough filter followed you, and it's not always the behavior you expect or want.

To go back to a global, unfiltered view, you need to clear it. Let's look at the easy, built-in way and a more robust, custom way to handle this.

Method 1: Use the Built-In Back Button

The simplest way to clear a drillthrough filter is to use the dedicated "Back" button Power BI automatically adds to your report. It's designed to return you to the previous page and remove the drillthrough context at the same time.

Here’s how it works:

1. Navigate to your main summary page.
2. Right-click a data point (e.g., a bar on a chart or a row in a table) that has drillthrough enabled.
3. Select Drillthrough and choose your destination page.
4. You'll land on the detail page, and you'll see a small "back arrow" icon (<) appear in the top-left corner of your report header.
5. In Power BI Desktop, you must Ctrl + Click this back button. In the Power BI Service (online), a simple click will do.

When you use this button, Power BI navigates you back properly and clears the filter. If you were to then navigate to another page, the "sticky filter" would be gone.

Graphed

Build AI Agents for Marketing

Build virtual employees that run your go to market. Connect your data sources, deploy autonomous agents, and grow your company.

Build Your First Agent

Why This Is Important

The key takeaway is that you must use this specific Back button. If you ignore it and simply click on the original report tab at the bottom of the page to navigate back, the drillthrough filter will remain active. Teaching your users to use the back arrow is the quickest solution for this issue.

Method 2: Create a Manual "Clear Selection" Button with Bookmarks

While the back button works perfectly, it's not always the most obvious feature for new users. A clearer, more intentional way to handle this is to add a dedicated "Clear Filters" or "Reset View" button directly on your drillthrough detail page.

This gives your users an explicit way to remove the filter without having to navigate away from the page. We accomplish this using Power BI’s Bookmarks functionality.

This process sounds a little technical, but it’s quite easy once you do it once.

Step 1: Set Your Page to an Unfiltered State

First, navigate to your drillthrough detail page. Use the Filters pane on the right-hand side to manually clear any and all filters applied to the page. You want the visuals to be showing their default, completely unfiltered state.

Step 2: Create a Bookmark of the "Cleared" State

A bookmark in Power BI saves the current state of a report page. We're going to create one that remembers this completely unfiltered view.

• Go to the View tab in the Power BI ribbon.
• Click on Bookmarks to open the Bookmarks pane.
• With your page in its cleared state, click the Add button in the Bookmarks pane. A new bookmark will appear.
• Rename this bookmark to something descriptive, like "ResetDetailPageFilters" or "ClearSalesDrillthrough."

Step 3: Configure the Bookmark Settings

This is the most important step. We only want the bookmark to affect the filters, not the user's view or what they have selected.

• In the Bookmarks pane, click the ellipsis (...) next to the bookmark you just created.
• A menu will appear. You need to uncheck Display and Current Page.
• Make sure only Data is checked. This tells Power BI, "When this bookmark is activated, only change the data filters to the saved state, leave everything else alone."

AI Agents for Marketing

Crash Course

Graphed

Free PDF · the crash course

AI Agents for Marketing Crash Course

Learn how to deploy AI marketing agents across your go-to-market — the best tools, prompts, and workflows to turn your data into autonomous execution without writing code.

Download the PDF

Step 4: Add and Configure a Button

Now we just need something for the user to click on.

• Navigate to the Insert tab in the ribbon.
• Click Buttons and choose a button type. The Blank button is usually the most flexible, but you can also use an icon or an image.
• Position and resize the button on your detail page.
• Select the button, and in the Format pane on the right, customize its appearance. Under "Style," you can add text like "Clear Selection."

Step 5: Link the Button to the Bookmark

Finally, let's wire it all up.

• Select your newly created button.
• In the Format pane, find the Action section and toggle it on.
• Expand the Action section. For Type, select Bookmark.
• For the Bookmark option, choose the bookmark you created earlier (e.g., "ResetDetailPageFilters").
• Under "Tooltip," you can add some helper text like, "Click to remove the drillthrough filter and view all data." This text will appear when a user hovers over the button.

Now, when a user drills through to this page, they can simply click your "Clear Selection" button, and the page will instantly reset to its unfiltered state, all without them ever leaving the page or having to know about the sometimes-hidden back arrow.

Final Thoughts

Dealing with sticky drillthrough filters in Power BI is a matter of understanding the navigation intended by the tool. For a quick fix, always use the back button Power BI provides. For a cleaner and more user-friendly experience, the five-minute effort to create a bookmark-powered "Clear" button will make your reports significantly easier for everyone to use.

While Power BI is a powerful tool for visual analysis, getting reports to work just right often means digging into settings menus and learning specific workflows like bookmarks. We designed Graphed to create a more fluid relationship with your data. Instead of building interactions with bookmarks, you can simply have a conversation. You can ask for a high-level view, then ask a follow-up question to drill down into a specific segment. To go back, you just ask for the big picture again - no clearing filters or resetting views required.