Graphed LogoGraphed
Graphed LogoGraphed
How It WorksAgentsIntegrationsPricing

How to Restrict Filter in Power BI

Cody Schneider••8 min read

You’ve carefully designed a Power BI report, added your slicers for easy filtering, and everything works… a little too well. A date slicer you added to filter your sales trend chart is also filtering your "Total All-Time Sales" KPI card, which you need to remain static. This article will show you exactly how to take back control and restrict how filters and slicers interact with your visuals in Power BI, from simple clicks in the user interface to powerful DAX functions.

GraphedGraphed

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.

Watch Graphed demo video

Understanding Power BI's Default Filter Behavior

By default, Power BI is designed to be highly interactive. When you add a filter or a slicer to a report page, it's automatically wired to affect every other visualization on that same page. If you slice by "2023," every chart and card updates to show data only for 2023. This is often exactly what you want, as it creates a dynamic, connected dashboard experience.

The problem arises when you have specific visuals that are meant to provide a broader context. Classic examples include:

  • KPI Cards: A card showing "Total Sales" should ideally show the grand total, regardless of what year or region the user selects in a slicer.
  • Comparison Charts: A chart showing sales by category for a selected year might sit next to another chart showing company-wide sales for all years. The slicer should only affect the first chart.
  • Reference Tables: You might have a simple table listing all products, which you want to remain unchanged as a reference, even when a user filters the report by a specific product category.

Fortunately, Power BI provides an intuitive tool to manage these exact scenarios: Edit Interactions.

The Easiest Method: Using “Edit Interactions”

"Edit Interactions" is your primary, go-to tool for controlling the relationship between slicers and visuals on a report page. It allows you to define, on a visual-by-visual basis, how a selected slicer (or any visual used as a filter) will affect others.

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.

Step-by-Step Guide to Accessing Edit Interactions

Getting to the Edit Interactions controls is simple:

  1. First, select the slicer or visual that is acting as the filter. For this example, click on the year slicer that you want to control.
  2. Navigate to the Format tab in the main Power BI ribbon at the top of the screen.
  3. Click on the Edit Interactions button.

Once you click it, you’ll notice small icons appearing in the top right corner of all the other visuals on the page. These icons represent the different interaction modes you can choose.

Understanding the Interaction Icons

When you select a slicer and enter the "Edit Interactions" mode, you'll see up to three icons on other visuals. These icons let you decide how the slicer and the visual will talk to each other.

  • Filter (Funnel icon): This is the default setting. When a user makes a selection in the slicer, it will strictly filter the data in the visual. Any data that doesn’t match the selection is completely removed from the visual’s calculation.
  • Highlight (Bar chart with highlight icon): This option is a bit softer than a filter. Instead of removing data, it highlights the portion of the data that matches the slicer selection and shows the rest of the data in a dimmed or faded context. This can be great for seeing a selection's contribution to a larger total but is not available for all visual types.
  • None (Circle with a line through it): This is the key to restricting a filter. Selecting this option completely breaks the connection between the slicer and that specific visual. The visual will completely ignore any selections made in the slicer and will always show its data based on the broader filter context (or no filters at all).

Practical Example Walkthrough

Let's go back to our initial problem: a "Year" slicer is incorrectly filtering a KPI card meant to show "Total All-Time Sales."

  1. Select the "Year" slicer on your report page.
  2. Go to the Format ribbon and click Edit Interactions.
  3. Locate your "Total All-Time Sales" KPI card. You will see the small interaction icons in its corner. By default, the "Filter" icon is likely selected.
  4. Click on the None icon (the circle with a line) on the KPI card.
  5. Click Edit Interactions again to turn the mode off.

That's it! Now, try using your "Year" slicer. You’ll see all the other visuals on the page update as you select different years, but your "Total All-Time Sales" KPI card will remain unchanged, always displaying the grand total. You have successfully restricted the filter from affecting that visual.

Synchronizing Filters Across Report Pages

Sometimes you need the same slicer to appear on multiple pages of your report. Having to reset the slicer on each new page is not a great user experience. This is where the Sync Slicers pane comes in handy.

Using the Sync Slicers Pane

You can find this pane by going to the View tab in the ribbon and checking the box for Sync Slicers. When you select a slicer, this pane shows a list of all the pages in your report. You can choose:

  • Which pages the slicer should be visible on.
  • Which pages the slicer’s selection should apply to (even if it's not visible).

The important part here is how this connects with Edit Interactions. Even if you sync a slicer's selection across five pages, you can still customize its interactions on a page-by-page basis. On the "Sales Overview" page, the synced year slicer can filter all charts. But on the "Historical Performance" page, you can use Edit Interactions to make it ignore a "Company Lifetime Revenue" visual.

GraphedGraphed

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.

Watch Graphed demo video

Advanced Control with DAX Functions

While "Edit Interactions" is perfect for managing visual behavior on the report canvas, there are times you need more robust, permanent control. You might want to create a measure that, by its very nature, always ignores certain filters. This is where Data Analysis Expressions (DAX) come in.

By writing specific measures, you can programmatically remove or modify the "filter context" — the set of active filters being applied to a calculation.

The CALCULATE and ALL Functions

The two most important DAX functions for this job are CALCULATE and ALL.

  • CALCULATE: This is a powerhouse DAX function. It evaluates an expression (like a sum or a count) within a modified filter context.
  • ALL: This function returns all the rows in a table or all the values in a column, ignoring any filters that might have been applied.

When you combine them, you can create a measure that ignores filters. For our "Total All-Time Sales" KPI, instead of using the standard SUM(Sales[SalesAmount]), you could create a specific measure like this:

Total Sales All Time = 
CALCULATE(
    SUM(Sales[SalesAmount]),
    ALL(Sales)
)

Let's break it down: ALL(Sales) creates a virtual table of the entire 'Sales' table with no filters applied. CALCULATE then computes the SUM over this unfiltered virtual table. The result? This measure will always return the grand total of sales, no matter what the user clicks in a slicer related to the 'Sales' table.

When to Use DAX vs. Edit Interactions

So which method should you choose?

  • Use Edit Interactions when you need a quick, visual-level adjustment on a single report. It's fast, intuitive, and doesn't require writing code. It controls the UI layer.
  • Use DAX Measures when you want to build the logic directly into your data model. A DAX measure is reusable across your entire report and will always behave consistently. It’s essential for creating more complex calculations like "Percentage of Grand Total," where you need both the filtered value and the unfiltered total in the same formula.

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.

A Quick Note on Cross-Filter Direction

Occasionally, you might find filters behaving in unexpected ways due to your data model setup. In Power BI’s Model View, relationships between tables have a direction, indicated by an arrow. Usually, this direction is "single," meaning a filter on one table (like a 'Date' dimension table) filters a related table (like your 'Sales' fact table).

If a relationship is set to "Both" (bidirectional), filters can travel "uphill" against the arrow. For example, filtering your 'Sales' table could also filter your 'Date' table. While powerful, this can sometimes lead to behavior that is difficult to predict. If Edit Interactions and DAX aren't solving your issue, checking the cross-filter direction of your relationships is a good troubleshooting step.

Final Thoughts

Restricting filter behavior is a fundamental skill for creating clean, user-friendly Power BI reports. By mastering "Edit Interactions," you can easily control how slicers and visuals communicate. For more permanent or complex scenarios, DAX functions like CALCULATE and ALL empower you to build powerful, reusable measures that are immune to specific filters.

While mastering these Power BI features is rewarding, sometimes you need insights without manually shaping every calculation and interaction. We created Graphed because we believe getting answers from your data should be as simple as asking a question. Instead of configuring filter contexts, you can simply ask, "What were our total sales from Shopify last month compared to Facebook Ads revenue?" and get an instant, properly scoped visualization, letting you focus on the insight, not the setup.

Related Articles