How to Unfilter in Power BI

It’s a familiar story for anyone working with Power BI: you’ve sliced, diced, and filtered your data to find a specific insight, but now you want to go back to the big picture and can't figure out how to reset your view. An unintended filter is hiding somewhere, throwing off all your numbers, and you’re stuck clicking around trying to find the culprit. Learning to expertly manage and clear filters is a fundamental skill that transforms Power BI from a potentially confusing tool into a powerful, interactive dashboarding solution. This guide will walk you through all the different ways to unfilter in Power BI, from the most basic clicks to creating your own reset buttons.

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

First, A Quick Look at the Different Types of Filters

Before clearing filters, it helps to understand where they can live in your Power BI report. Filters can be applied at several different levels, and knowing which one you’re dealing with is the first step to clearing it.

There are typically three main places you'll find filters in the Filters Pane, which usually appears on the right side of your report:

• Visual-level filters: These apply only to a single, selected visual. For example, filtering one line chart to show data only for "Facebook Ads" without changing any other charts on the page.
• Page-level filters: These apply to all the visuals on the current page of the report. This is useful for creating a page focused on a specific region, quarter, or product line.
• Report-level filters: These apply to every visual across all pages in the entire report. A common use case is filtering the report to exclude test data or to only show data from after a specific launch date.

Besides the Filters pane, slicers and even interactions between visuals can also create filters. We’ll cover how to handle those, too.

The Simplest Method: Using the Filters Pane to Clear Filters

The most direct way to unfilter your report is by using the built-in options in the Filters pane. This is your command center for managing most filter actions.

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

How to Clear a Single Filter

If you just want to remove one specific filter without affecting others, you can do it with a single click. Look at your Filters pane and find the filter "card" you want to remove.

To clear it, simply click on the eraser icon labeled "Clear filter" at the top-right corner of that little card. The filter will instantly be removed, and the affected visual(s) will update.

Example: You’ve filtered a bar chart to show sales only from "California." You've answered your question and now want to see all states again. You would find the "State" filter card under "Filters on this visual" and click the eraser.

How to Clear ALL Filters at Once

Sometimes your report is a complex web of different filters at the visual, page, and report levels. Instead of hunting for each one, Power BI gives you a master reset button. At the very top of the Filters pane, you’ll see some overarching commands, like "Clear all filters." This appears as its own link at the report level.

This button — or a page-specific reset link — will remove ALL filters you’ve added at a particular level, instantly returning your page or entire report to its unfiltered state. This is especially useful for end-users who may have applied several filters while exploring the data and want a quick way to get back to the default view.

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 About Cross-Filtering? The "Invisible" Filter

Have you ever clicked on a bar in one chart and watched everything else on the page suddenly get filtered? That’s called cross-filtering or cross-highlighting. It's a fantastic feature for interactive analysis, but it can be confusing if you don't realize you’ve activated it.

For example, in a report showing sales by country and another visual showing sales by product category:

• Clicking on "United States" in the country map will filter the product category chart to show only sales data from the U.S.

How do you "unfilter" this? It’s even easier than using the Filters pane:

• Click the same element again. Just click on "United States" in the map one more time, and the filter will be removed.
• Or, click in the blank space of the visual. Clicking anywhere in the white space of the visual you used to filter (the country map) will also clear the selection and unfilter the other visuals.

Adding a "Clear Filters" Button to Your Report

If you're building a report for others, they might not know to look inside the Filters pane. To create a more intuitive user experience, you can add a dedicated "Clear Filters" button directly onto the report canvas. This involves using another powerful Power BI feature: Bookmarks.

A Bookmark saves the "state" of a report page — including any filters. By creating one bookmark for the default, unfiltered state, you can link a button to it.

Here’s how to set it up step-by-step:

Step 1: Get Your Page to the Default State

First, manually clear any and all filters/slicers on the page so it's showing the default view you want users to return to.

Step 2: Create a Bookmark

1. Go to the View tab in the ribbon at the top.
2. Click to open the Bookmarks pane.
3. In the Bookmarks pane, click Add. A new bookmark will appear.
4. Rename it to something intuitive, like "Reset Filters."
5. Click the three dots (...) next to your new bookmark and make sure "Data" is checked. This ensures the bookmark saves the current filter state (which is currently no filters). You may want to uncheck "Display," which controls things like visual visibility if you're not trying to toggle that.

Step 3: Add a Button to Your Report

1. Go to the Insert tab on the ribbon.
2. Click Buttons and choose either a ready-made option or Blank to create a custom one.
3. Position and resize the button on your report canvas where you want it.

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: Link the Button to Your Bookmark

1. With your new button selected, go to the Format pane (the paintbrush icon).
2. Turn the Action toggle to On.
3. Expand the Action menu and set the Type to Bookmark.
4. Under the Bookmark dropdown, select the "Reset Filters" bookmark you just created.
5. Optionally, you can go into the Button style settings and add Text, like "Clear All Selections," so users know what it does.

Now, whenever a user clicks that button, it will activate the bookmark and instantly revert the page to its saved (unfiltered) state. This adds a level of professionalism and user-friendliness to your dashboards.

Troubleshooting Common "Unfiltering" Problems

Still having trouble? Here are a few other common sources of filters that can be tricky to spot.

• Slicers: Slicers are basically visible, on-page filters. They also have an eraser icon in their header. Clicking it will clear the selections within that slicer. Remember that multiple slicers might be interacting with each other.
• Drill-Through Filters: A drill-through is when you right-click a data point and are taken to another report page with details filtered specifically for that data point. Power BI automatically adds a "back" arrow button in the top-left corner of the destination page. Clicking this arrow is the intended way to "un-drill" and clear that context-specific filter.
• Locked or Hidden Filters: The person who built the report can lock or even hide filters from end-users in the Filters pane. If you’re consuming a report and can’t clear a filter, it’s possible it was done by design to ensure the report always shows a specific subset of data.

Final Thoughts

Understanding how Power BI applies and clears filters is crucial for building clear, functional reports and ensuring you’re analyzing the right data. Once you get familiar with the Filters Pane, cross-filtering behaviors, and more advanced tools like reset buttons, you gain much more control over the narrative your data tells.

Eventually, building even simple interactions like a reset button in Power BI requires navigating multiple panes and settings. This is a common-sense feature, but the setup still isn't as straightforward as just asking for what you want. We created Graphed because we believe anyone should be able to get answers from their data and insights without learning the technical complexities of BI tools. Instead of managing filters, creating bookmarks, and editing interactions, you can simply describe what you want to see - "Show me US traffic vs UK traffic," or, "rebuild this dashboard to show monthly trends" - and let AI handle all the data wrangling and report setup for you.