How to Lock a Visual in Power BI from Slicer

Ever built a Power BI dashboard where you need one specific visual to stay put while your slicers filter everything else? It's a common need: you might want a KPI card showing total company sales to remain constant, even while a user drills down into regional or product-specific data. This article will show you exactly how to lock a visual and make it ignore slicers, using two effective methods.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

Why Would You Want to Stop a Slicer from Filtering a Visual?

Power BI is designed for interactivity, and the default behavior is for slicers to affect every visual on the page. This is usually what you want, but there are several scenarios where overriding this default is essential for creating a more insightful report.

• Showing Big-Picture Totals: You might have a KPI card for "Total Revenue" or "Total Customers." You want these benchmark numbers to stay visible as a reference point while users explore data from specific time periods or regions.
• Creating Comparison Views: A key use case is comparing a part to the whole. For instance, filtering sales for the "West" region and seeing that data in a bar chart right next to another chart that continues to show sales for all regions.
• Displaying Unchanging Goals or Targets: If you have a target or budget that applies to the entire company, you don't want it to be filtered down when a user selects a specific department. Keeping that visual static provides necessary context.
• Maintaining a Reference Chart: You may have a line chart showing a trend over the entire year that you want to keep on the screen as users slice and dice data by individual quarters or months in other visuals.

Fortunately, Power BI gives you direct control over these interactions without needing complicated workarounds.

Method 1: Using the "Edit Interactions" Feature

The easiest and most straightforward way to prevent a slicer from affecting a visual is by using Power BI’s built-in "Edit Interactions" feature. This tool lets you explicitly define how visuals on a report page filter one another.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

Step-by-Step Guide to Editing Interactions

Let's walk through an example. Imagine you have a report with two visuals: a slicer for "Region" and a card displaying "Total Sales." By default, selecting a region in the slicer will change the Total Sales value on the card. Here’s how to stop that.

1. Select the Slicer: First, click on the slicer visual that you want to control. This is the "controller" visual. In our example, this is the "Region" slicer.
2. Open the "Format" Ribbon: With the slicer selected, look at the top ribbon in Power BI Desktop. You'll see a contextual menu appear called "Format." Click on it.
3. Click "Edit Interactions": Within the "Format" ribbon, you will find an option called "Edit Interactions." Click this button to enter interaction-editing mode.
4. Identify the Interaction Icons: Once you enter this mode, you'll notice small icons appearing at the top-right corner of all the other visuals on the report page. These icons control how the selected slicer affects each individual visual. You'll typically see two icons:
5. Choose the "None" Interaction: Now, find the target visual you want to "lock." In our example, this is the "Total Sales" card. Hover over it and click the "None" icon.
6. Turn Off "Edit Interactions": Once you’ve set the interaction to "None," you can click the "Edit Interactions" button in the Format ribbon again to exit the editing mode. The little icons will disappear.

That's it! Now, when you select a region in your slicer, all other visuals on the page will filter as expected, but your "Total Sales" card will remain completely unchanged, always displaying the grand total. You can repeat this process for multiple slicers and visuals to customize your dashboard's behavior precisely.

Method 2: Gaining More Control with DAX Functions

While "Edit Interactions" is perfect for straightforward on/off control, sometimes you need more nuance. What if you want a visual to ignore most slicers but still react to a specific one, like a "Year" slicer? This is where DAX (Data Analysis Expressions) comes in. By creating a specific DAX measure, you can write filtering logic directly into your calculations.

The two most common formulas for this are ALL() and ALLEXCEPT().

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

Using the ALL() Function to Ignore All Filters

The ALL() function tells Power BI to ignore any and all filters applied to a table or specific columns. It essentially gives you a "get me the total no matter what" command.

Let's recreate our "Total Sales" card example, but this time with a DAX measure.

1. Create a New Measure: In the Home ribbon, click "New Measure."
2. Write the DAX Formula: In the formula bar, you would write something like this:

Total Company Sales = CALCULATE(SUM('Sales'[Revenue]), ALL('Sales'))

How it works:

• SUM('Sales'[Revenue]) is the base calculation we want to perform.
• CALCULATE() allows us to modify the "context" or filters under which that calculation runs.
• ALL('Sales') is the filter modifier. It tells CALCULATE() to remove all filters from the 'Sales' table before summing the revenue.

Now, if you use this "Total Company Sales" measure in a card visual, it will be completely immune to any slicer that filters columns from the 'Sales' table (like Region, Product, etc.). "Edit Interactions" won't even have to be used, because the universal total is baked right into the measure's logic.

Using the ALLEXCEPT() Function for Partial Filtering

The real power of DAX comes with functions like ALLEXCEPT(). This function removes all filters from a table except for filters on the columns you specify.

Imagine you want a visual to show the total annual sales. You want it to ignore slicers for "Region" and "Product," but you do want it to update when the user selects a different year from a "Year" slicer.

Here's how you'd write the measure:

Annual Sales Unfiltered = CALCULATE(SUM('Sales'[Revenue]), ALLEXCEPT('Date', 'Date'[Year]))

How it works: ALLEXCEPT('Date', 'Date'[Year]) instructs CALCULATE() to ignore all filters coming from the 'Date' table, with one exception: stay responsive to any filter applied to the 'Date'[Year] column.

When you use this measure in a visual, it will brilliantly ignore your "Region" slicer but dynamically update when you use your "Year" slicer. This gives you incredibly powerful and granular control over your report's interactivity.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

A Few Best Practices

Regardless of the method you choose, keep these tips in mind to create clear and user-friendly reports:

• Be Explicit in Your Titles: If a visual is locked, make it obvious to the user. Instead of labeling a card "Revenue," title it "Total Company Revenue" to avoid any confusion about why it's not changing.
• Use Visual Cues: Consider visually separating your static visuals from your dynamic ones. You could place all static "Total" KPIs in a header section with a slightly different background color.
• Test Every Interaction: Before publishing, click through every slicer and interaction to ensure the dashboard behaves exactly as you intended. It's easy to miss a single setting, which can throw off the user experience.

Final Thoughts

Controlling how visuals interact is a fundamental skill for building effective and intuitive Power BI dashboards. By mastering the simple "Edit Interactions" feature, you can quickly lock specific visuals to display unchanging totals or KPIs. And for more complex scenarios, DAX functions like ALL() and ALLEXCEPT() provide the flexibility to dictate exactly which filters a calculation should respect and which it should ignore.

We know that mastering the nuances of tools like Power BI can involve a significant learning curve with countless menus, modes, and functions. Features like "Edit Interactions" are powerful but are just one small piece of a complex puzzle. That's why we built Graphed to simplify the entire process. Instead of hunting through ribbons and writing DAX formulas, you can just connect your marketing and sales data sources and ask questions in plain English like, "Show total sales for all regions in a card, and create a bar chart of sales by product." Our AI data analyst builds the interactive dashboard for you, saving you from the technical overhead so you can focus on the insights, not the setup.