How to Clear Drill Through Filters in Power BI

Drillthrough filters in Power BI can be incredibly powerful for diving deep into your data, but they often come with a frustrating quirk: they don't always clear themselves. This article will show you exactly how to create a simple, reliable "clear filters" button to reset your drillthrough pages, ensuring your reports are always accurate and easy to use.

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?

Before we fix the problem, let's quickly recap what a drillthrough filter is. Imagine you have a summary dashboard showing total sales by region. You notice that the 'North' region had an exceptional month. A drillthrough allows you to right-click on 'North' and jump to a different, more detailed report page that is automatically filtered to show only the data for that region.

In essence, drillthrough is a feature that connects a summary view to a detailed view. It creates a dedicated "destination" page that provides context for a single data point from a "source" page. When you drill through, Power BI passes the context - in this case, "Region = North" - to the destination page, filtering every visual on it accordingly.

This is extremely useful for a few reasons:

• Focus: It lets users explore details without being overwhelmed. Instead of trying to cram every metric onto one massive dashboard, you can create clean, focused pages for specific analyses.
• Clarity: It provides a clear path from a high-level KPI to the underlying data that drives it. This helps answer follow-up questions like, "Why were sales so high in the North region?"
• Interactivity: It makes reports more dynamic and engaging, encouraging users to explore connections and uncover insights on their own.

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

Why "Sticky" Drillthrough Filters Are a Problem

The core challenge with drillthrough arises from what’s often called "sticky filters." After you've drilled through to a details page (let’s say for the 'North' region), that filter context remains active on the page. If you then use the main page navigation tabs at the bottom to switch to another page and then come back to the 'North' details page, it will likely still be filtered for 'North'.

This creates a confusing experience for the user. They might forget they previously drilled through and assume the filtered view they are seeing represents the complete dataset. This can lead to incorrect conclusions and undermines trust in the report. For example, a stakeholder might see the page filtered for 'North' and think those are the total company-wide numbers, leading them to make a bad decision based on incomplete information.

Manually telling every user to find the tiny 'x' in the Filters pane to clear selections is not practical. The best reports are intuitive and guide the user. That’s why setting up a clear, dedicated way to reset the page is not just a nice-to-have, it's a fundamental part of good report design.

How to Clear Drillthrough Filters with a Button

The most user-friendly and reliable solution to the sticky filter problem is to add a "Clear Filters" button directly to your drillthrough destination page. The user lands on the filtered page, gets their specific insight, and then has an obvious option to click a button that resets the page to its default, unfiltered state. This is done using Power BI's Bookmarks feature.

Here’s the step-by-step process:

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 1: Get Your Destination Page Ready

First, navigate to your drillthrough details page - the page that users land on after they drill through. If there are any filters or slicers currently active (from a previous test, for example), clear them all manually. Go to the Filters pane and click the eraser icon to remove any drillthrough filters.

You should now be looking at the page in its default state, showing all the data without any specific drillthrough context applied. This is the state you want the page to return to when the user clicks your future button.

Step 2: Create Your "Reset" Bookmark

Bookmarks in Power BI save the state of a report page. We'll create a bookmark that saves the current, unfiltered view you just set up.

1. On the top ribbon, go to the View tab.
2. Click on Bookmarks to open the Bookmarks pane (it will usually appear on the right side).
3. With your destination page still in its unfiltered state, click the Add button in the Bookmarks pane. A new bookmark will appear, likely named something like "Bookmark 1."
4. Rename the bookmark to something intuitive like "Clear Drillthrough Filters" or "Reset Page View." This makes it easier to manage later, especially if your report has multiple bookmarks.

Now, you have a saved state of the unfiltered page. But there's one more crucial adjustment to make.

Step 3: Important - Adjust the Bookmark's Data Setting

By default, bookmarks capture the data context (like filters and slicers) that are active when they are created. We need to tell this specific bookmark to not save the data, but instead to update the display properties, which includes resetting filters back to a default state.

1. In the Bookmarks pane, find the "Clear Drillthrough Filters" bookmark you just created.
2. Click on the three dots (...) next to the bookmark name to open the options menu.
3. Uncheck the "Data" option. This is the most critical part of this entire process. Unchecking 'Data' tells the bookmark to reset the visual styles and filters but not to lock it to the specific data slice that was present when you created it. It essentially reverts the filters to their default setting.
4. After unchecking "Data," it's a good practice to click the three dots again and select Update to ensure the new setting is saved to the bookmark.

Now your bookmark is perfectly configured. The final step is to create a button that triggers it.

Step 4: Create and Configure the Button

Now, let's add the button that your users will click.

1. Stay on your destination page. On the top ribbon, go to the Insert tab.
2. Click Buttons and select a button shape. The "Blank" option is highly versatile.
3. A blank button will appear on your canvas. Drag it to where you want it to appear (a corner or the top of the page is usually best).
4. Select the button. The Format pane will open on the right. Here you can customize its appearance.
5. Now, let's link the button to the bookmark. In the same Format pane, find the Action section.
6. Turn the Action toggle to On.
7. Expand the Action menu. For Type, select Bookmark.
8. In the Bookmark dropdown that appears, select your "Clear Drillthrough Filters" bookmark.

That's it! Your button is now fully functional.

Step 5: Test It Out

The final part is ensuring it works as expected.

1. Go back to your main summary page (the source page).
2. Right-click on a data point and select Drill through > [Your Destination Page Name].
3. You'll be taken to the destination page, and it will be filtered for the data point you selected. All the visuals should reflect this specific context.
4. Now, locate the "Clear Filters" button you just created. Ctrl + Click the button to simulate a user click in Power BI Desktop.
5. Instantly, all the filters should be removed from the page, and the visuals should refresh to show the complete dataset.

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

The Built-in Back Button: What It Does

It's worth noting that Power BI automatically adds a small 'back arrow' icon in the top-left corner of the report whenever a user successfully lands on a drillthrough page. This is a default Power BI behavior.

This button is designed to take the user back to the previous screen they were on - in this case, the source summary page. Educating your users to use this dedicated back arrow (instead of the main page navigation tabs at the bottom) is good practice. It aligns with the intended navigation flow and typically manages the filter context correctly for the user session.

However, it does not solve the core issue of a user manually navigating away from and back to the details page, which can leave the sticky filter in place. The dedicated "Clear Filters" button works in tandem with the default back button to create a truly seamless and foolproof user experience.

Final Thoughts

In short, while Power BI's drillthrough feature offers fantastic analytical depth, its "sticky filters" can create confusion. By adding a simple button linked to a properly configured bookmark, you can give your users an easy and intuitive way to reset the page, ensuring they always see the right data at the right time.

While mastering details like bookmark actions is a must for BI tools like Power BI, we created Graphed to remove this complexity entirely. Instead of configuring intricate drillthroughs and reset buttons, you can connect your data sources once and then just ask for what you need in plain English. Want to see details about last month's best-performing campaign? Just ask, "Show me a breakdown of clicks, cost, and conversions for our top campaign last month," and Graphed builds the report instantly, keeping you focused on insights, not setup.