How to Turn Off Interactions in Power BI

Ever click on a bar chart in your Power BI report only to watch your perfectly arranged KPI cards and tables instantly change? You're not alone. This automatic interactivity is one of Power BI's most powerful features for data discovery, but it can also be a major frustration when you need specific visuals to remain static. This article will show you exactly how to take control of this behavior by editing and turning off visual interactions.

Graphed

Still Building Reports Manually?

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

Watch the Demo

What Are Visual Interactions in Power BI?

In Power BI, "interactions" are the default settings that link all the visuals on a single report page. When you select a data point on one visual - like clicking a country in a map or a segment in a pie chart - it automatically signals every other visual on the page to update based on your selection. This process is known as cross-filtering or cross-highlighting.

This is incredibly useful for exploring your data on the fly. You can quickly drill down to see, for instance, how sales from a specific region are distributed across different product categories. However, there are common scenarios where this behavior is the exact opposite of what you want:

• Executive Dashboards: You may have key performance indicator (KPI) cards displaying total company revenue or total customers. You want these numbers to remain fixed as a high-level reference, not change every time someone clicks on a different chart.
• Comparative Analysis: You might be comparing two separate periods, like this year's sales versus last year's sales, in side-by-side tables. Clicking on one should not filter the other.
• Reference Visuals: Sometimes a visual is just there for context, like a table of definitions or sales targets. You don't want slicers or other charts to affect it.

Fortunately, Power BI gives you granular control to define exactly how - or if - visuals interact with each other. This allows you to build more intuitive and user-friendly reports.

Filter vs. Highlight: Understanding Your Control Options

Before turning interactions off completely, it's important to understand the three modes you can choose from. When you enter the "Edit interactions" mode, you'll see controls on each chart that let you pick one of three options: Filter, Highlight, or None.

Filter Mode (The Aggressive Default)

This is the default mode for most visuals. When you apply a filter, Power BI removes any data that doesn't match your selection. It completely re-calculates the visual to show only the filtered data.

Example: You have a bar chart showing sales by country and a line chart showing sales over time. If you click on "USA" in the bar chart, the line chart will transform to display only the sales trend for the USA. All data from other countries temporarily disappears from that chart's view.

Graphed

Still Building Reports Manually?

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

Watch the Demo

Highlight Mode (The Insightful Middle Ground)

Highlight mode is less drastic. Instead of removing data, it simply fades out the data that doesn't match your selection while keeping the relevant portion in full color. This is excellent for seeing a part-to-whole relationship.

Example: Using the same sales report, if you set the interaction to highlight and click on "USA" in the bar chart, the entire sales trend line will still be visible. However, the background data (from all other countries) will be grayed out, while the portion of the line representing USA sales is brightly highlighted. This helps users understand how much the USA contributes to the overall trend.

None (The 'Do Not Disturb' Setting)

This option, represented by a circle with a line through it, completely disables the interaction. Selecting a data point on another visual will have absolutely no effect on the chosen chart or data element. This is the mode you'll use to lock down visuals like KPI cards or reference tables.

Step-by-Step Guide: How to Turn Off Interactions

Controlling visual interactions is straightforward once you know where to look. Let's walk through the process of making one visual ignore the filters from another.

Remember this crucial rule: First, select the visual that is DOING the filtering, then change the setting on the visual you want to AFFECT.

Step 1: Select the "Source" Visual

Start by clicking on the visual that you want to control. This is the "source" visual - the one your user will be clicking on. For example, if you don't want your "Sales by Region" pie chart to affect your "Total Revenue" KPI card, you must first click on the pie chart to select it.

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

With the source visual selected, look at the main ribbon at the top of the Power BI window. Click on the Format tab. Within this tab, you will see a button labeled Edit interactions.

Step 3: Activate Interaction Mode

Click the Edit interactions button. When you do, you'll notice small icons appearing in the top-right corner of all the other visuals on your report page. This indicates you're now in editing mode, ready to define the relationships.

Graphed

Still Building Reports Manually?

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

Watch the Demo

Step 4: Change the Interaction on the "Target" Visual

Now, locate the "target" visual - the visual you want to prevent from changing. In our example, this is the "Total Revenue" KPI card. Hover over it and you will see the interaction icons. The available options might be:

• A funnel icon for Filter
• A pie chart icon for Highlight
• A circle with a slash for None

To turn off the interaction completely, click the None (circle with a slash) icon. You'll see the icon become bold or black to confirm your choice. Now, when you click on a slice of your "Sales by Region" pie chart, the "Total Revenue" KPI card will remain completely unchanged.

Step 5: Repeat for Other Interactions

The changes you just made only define how the pie chart affects the KPI card. A different visual, like a slicer for product categories, will still affect the KPI card by default.

You must repeat the process for every interaction you want to disable. For instance, to fully lock your "Total Revenue" card, you'll need to:

• Select your product category slicer, then click "None" on the KPI card.
• Select your "Sales over Time" line chart, then click "None" on the KPI card.
• Select every other interactive visual on the page and repeat the process.

It's best to be methodical. Select one visual at a time and work through all the other visuals on the page, setting the appropriate interaction for each one.

Step 6: Deactivate Interaction Mode

Once you've configured all the interactions to your liking, click the Edit interactions button in the Format tab again. The small icons on your visuals will disappear, and your report will return to its normal state, but now with your new interaction rules applied.

Practical Examples for Turning Off Interactions

Let's ground this in a few common reporting scenarios to see how it works in practice.

Example 1: Locking Down an Executive KPI Dashboard

Most executive dashboards include a "hero" section at the top with headline numbers: Total Sales, Profit Margin, Customer Count, etc. These should provide a constant, at-a-glance summary of the business.

The Goal: Make sure the KPI cards never change, no matter what region, product, or time frame is selected in the other charts.

The Solution: For each and every interactive visual on the dashboard (your charts, slicers, maps), select it, enter 'Edit interactions' mode, and then set the interaction icon on all of your KPI cards to 'None'. It's tedious but ensures your main metrics are bulletproof.

Graphed

Still Building Reports Manually?

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

Watch the Demo

Example 2: Creating a Static Reference Table

Imagine you have a report analyzing team performance, and on the same page, you have a simple table outlining the monthly quota for each sales rep. You want users to be able to filter performance by date or deal size without making the "Quota" table disappear or change.

The Goal: Keep the "Quota" table always visible and fully intact.

The Solution: Follow the same logic as the KPI example. Select every slicer and chart on your report one by one, and for each one, go to the interaction settings on the "Quota" table and click the 'None' icon. This disconnects the visuals and turns your quota table into a static reference point for users.

Example 3: Comparing Two Tables Side-by-Side

A common request is to compare distinct data sets, like Marketing Qualified Leads (MQLs) in one table and Sales Qualified Leads (SQLs) in another. You might include a single slicer for a date range that affects both tables, but you don't want clicking on a row in the MQL table to filter the SQL table.

The Goal: Prevent cross-filtering between the two tables while allowing them to be filtered by a common slicer.

The Solution:

1. Click on the MQL table to select it.
2. Enter 'Edit interactions' mode.
3. On the SQL table visual, change the interaction to 'None'.
4. Click on the SQL table to select it.
5. While still in Edit interactions mode, go to the MQL table visual and change its interaction to 'None'.
6. Exit 'Edit interactions' mode.

This creates a two-way disconnection, allowing each table to be sorted and explored independently without affecting the other.

Final Thoughts

Controlling visual interactions is an essential skill for graduating from a basic report builder to a creator of polished, intuitive dashboards. By mastering the Filter, Highlight, and None options, you can dictate exactly how your audience experiences your data, preventing confusion and guiding their focus to the insights that matter most.

We believe getting insights from your data shouldn't require clicking through dozens of hidden settings menus. The reality of BI tools is often a manual, time-consuming process of customization. That's why we created a way to describe the dashboard you want in simple language and have it built for you. With Graphed, we handle the technical overhead by connecting directly to your data sources and letting you build live, interactive reports just by asking questions, skipping right to the valuable insights.