How to Unsync Filters in Power BI

Ever built a beautiful Power BI dashboard, only to find that clicking one slicer sends every single chart into a filtering frenzy? It's a common frustration. You want to see sales for a specific region, but you don't want your main KPI card for "Total Company Revenue" to change along with it. This article will show you exactly how to take back control and unsync slicers and filters, so your visuals only interact when you want them to.

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 Do My Power BI Filters Sync Automatically? The Logic Behind It

Before diving into the fix, it helps to understand why Power BI behaves this way. The platform is designed for dynamic, interactive reporting. By default, when you place multiple visuals on a report page, Power BI assumes you want them all to talk to each other. When you click a data point on one chart - say, the "USA" bar in a "Sales by Country" chart - it automatically tries to filter or highlight every other visual on the page to reflect that selection.

This is called cross-filtering or cross-highlighting, and most of the time, it's exactly what you want. It's what makes a dashboard feel connected and allows users to explore data intuitively. You click a region, and you see the top products, salespeople, and trends for just that region.

The problem arises when you have specific visuals that should remain static to provide context or a high-level summary. Think of things like:

• Total company-wide revenue or user count
• Industry benchmark data
• A comparison chart showing performance against annual goals

When a user-selected filter changes these benchmark numbers, the dashboard loses its context and can become confusing. That's when you need to step in and manually unsync the filter.

The Main Event: Using 'Edit Interactions' to Control Your Filters

The primary tool for managing this behavior in Power BI is called Edit Interactions. This feature lets you define, on a visual-by-visual basis, how selections in one chart or slicer affect another. It might sound complex, but it's a straightforward, click-based process.

Here's how to do it, step-by-step:

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 1: Select the Controlling Visual

First, click on the visual that is doing the filtering. In our example about seeing sales for one country, you would click on the "Sales by Country" chart, or the slicer that lets you select a country. This is a key point: you select the visual that initiates the action, not the visual you want to change.

Step 2: Navigate to the 'Format' Tab and Find 'Edit Interactions'

With the controlling visual selected, look at the main ribbon at the top of Power BI Desktop. Click on the Format tab. You will see an option called Edit Interactions. Click it.

Step 3: Understand the Interaction Icons

As soon as you click 'Edit Interactions', your report page will look a little different. Each of the other visuals on the page will now have small, faint icons in their top right corner. These icons represent how this visual will react to selections from your controlling visual.

You’ll see up to three types of icons:

• Filter (Funnel icon): This is the default setting. A selection will actively filter the data in this visual, showing only the relevant subset. For example, selecting "USA" will make a sales trend chart show only sales from the USA.
• Highlight (Bar chart icon): A selection will highlight the relevant portion of the data without removing the rest. For instance, in a stacked bar chart of total sales, the USA portion will be fully colored, while data from other countries will be faded. It maintains context while still drawing attention to your selection.
• None (Circle with a slash icon): This is the magic button we’re looking for. A selection will have no effect on this visual. It will remain completely unchanged, or "unsynced."

Step 4: Click the 'None' Icon to Unsync the Filter

Now, find the target visual that you want to protect from the filter - for instance, your "Total Company Revenue" KPI card. In the top corner of that card, click the 'None' icon. You have just told Power BI that whenever someone filters by country, this specific KPI card should ignore it completely.

Step 5: Turn Off 'Edit Interactions' Mode

Once you've set your desired interaction (or non-interaction), simply click the Edit Interactions button in the ribbon again to turn the feature off. The icons will disappear, and you can now test your dashboard. Click on "USA" again. The rest of your charts will filter as usual, but your KPI card will stay put, proudly displaying the total company revenue.

That's it! You've successfully unsynced a visual from a specific filter.

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

Putting It Into Practice: Common Scenarios

Knowing the steps is one thing, applying them effectively is another. Here are a few common scenarios where manually editing interactions is incredibly useful.

Scenario 1: Protecting Your Key Performance Indicators (KPIs)

This is the most common use case. Your dashboard has a header row with KPI cards showing total sales, total customers, or annual goals. These are designed to provide a bird's-eye view that a user can always refer to. For each slicer and filterable chart on your page, you should select it, enter 'Edit Interactions' mode, and set all of your main KPI cards to 'None'.

Scenario 2: Creating Comparison Views

Imagine you want to see a side-by-side comparison. On the left, you have a chart "Sales Performance for Selected Region." On the right, you have a chart "Total Company Sales Performance." You want a slicer to select a region that filters the left chart, but not the right one.

• Select the Region slicer.
• Enter 'Edit Interactions' mode.
• For the "Sales Performance for Selected Region" chart, make sure the 'Filter' icon is selected.
• For the "Total Company Sales Performance" chart, click the 'None' icon.

Now, your user can select a region and see how its performance compares directly to the company-wide trend, all on one screen.

Scenario 3: A Slicer for One Specific Visual

Sometimes you might have a crowded dashboard with a chart that needs its own dedicated filter that shouldn't touch anything else. For example, a map visual might need a 'Zip Code' slicer, but you don't want that zip code selection to filter your high-level sales and marketing charts.

To do this, select the 'Zip Code' slicer, enable 'Edit Interactions', and then go through every other visual on the page and click the 'None' icon, leaving only the map visual set to 'Filter'.

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

Leveling Up: When to Use DAX Instead

For more permanent or complex situations, controlling filter behavior with a DAX formula can be more robust. The 'Edit Interactions' feature works perfectly for presentation-layer adjustments, but DAX gives you control at the data model level.

For instance, if you always want a measure to ignore filters from a specific column (like 'Region'), you can use the ALL() function in your DAX formula.

A standard measure for total revenue would be:

Total Revenue = SUM(Sales[Revenue])

To create a measure that ignores any region filters, you would write:

Company Wide Revenue = CALCULATE(SUM(Sales[Revenue]), ALL(Sales[Region]))

Using the Company Wide Revenue measure in a visual automatically "unsyncs" it from any slicer or chart based on the 'Region' column. You wouldn't even need to use 'Edit Interactions.' You would use DAX when the rule is "this number should never be filtered by X," and 'Edit Interactions' when the rule is "on this page, I want to manage how this filter applies."

Tips for Managing Filter Interactions

• Be thorough. 'Edit Interactions' settings are configured for a single controlling visual at a time. If you have five different slicers on your page, you need to individually select each one and define its interactions with the other visuals.
• Test everything. After setting up your interactions, click around your dashboard as a user would. Select different filters and ensure everything behaves exactly as you intended. It's easy to miss one.
• Communicate with your users. If certain visuals are intentionally static, it can be helpful to add a small note or title indicating it, such as "Company-Wide Totals," so users aren’t confused about why it's not changing.
• Remember it's page-specific. The 'Edit Interactions' settings you configure apply only to the current page. The 'Sync Slicers' pane is a separate feature used to make a slicer's selections apply across different report pages if needed.

Final Thoughts

Taking control of filter interactions is a fundamental skill that elevates your Power BI reports from being merely functional to truly intuitive and user-friendly. By using the 'Edit Interactions' feature, you can guide your audience's analysis, protect key summary data, and build dashboards that tell a clear, unambiguous story.

This level of control is key, but we know firsthand that building detailed interactive reports can be complex and time-consuming. At Graphed , we've focused on making data analysis feel more like a conversation. Instead of clicking through numerous menus to configure filter logic, you can state your goal in plain English, like "Build a dashboard showing sales by representative but also include a separate KPI card for total team quotas." We handle the process of connecting data sources, analyzing the relationships, and visualizing the results, empowering you to build real-time reports in seconds, not hours.