How to Stop Filtering in Some Visualizations in Power BI

Method 1: Using the Edit Interactions Feature

The Edit Interactions feature in Power BI allows you to control how visuals interact with each other. Follow these steps to stop filtering in specific visualizations:

Steps to Use Edit Interactions

1. Select the Slicer or Filtering Visual
   Choose the slicer or the specific visual that is applying the filter.

2. Enable Edit Interactions

   • Navigate to the Format tab in the Power BI ribbon.

   • Click on Edit Interactions.

3. Modify Visual Interactions

   • After clicking Edit Interactions, you will see new icons appearing on the upper right corners of all other visuals on that page.

   • Locate the visualization you do not want to be affected by the filter.

   • Click on the None (circle with a slash) icon to disable filtering for that specific visualization.
     
     

Now, the selected visualization will no longer be affected by the specified filter or slicer.

Example

If you have a sales report where you want a table to remain static while allowing a bar chart to change based on slicer selection, use Edit Interactions to disable filtering on the table while keeping it active on the bar chart.

Method 2: Writing a Measure Using DAX

Another way to stop filtering is by using DAX measures. The ALL function inside the CALCULATE function can be used to remove filters from specific columns.

RemovingFilter = CALCULATE( Expression, ALL(List of Columns to remove filters) )

Example

If you have a measure calculating total sales but want to remove filters applied by slicers on a column named Category, use the following DAX measure:

TotalSales_NoFilter = CALCULATE(SUM(Sales[Amount]), ALL(Sales[Category]))

This ensures that TotalSales_NoFilter is always calculated without any filter applied to the Category column.

Use Case

If you have a report showing total sales across different regions, but you want to keep a KPI card showing overall sales without being affected by region filters, you can apply the ALL function to ignore filtering on the region column.

Final Thoughts

Both methods—Edit Interactions and DAX Measures—are effective ways to stop filtering in Power BI.

• Use Edit Interactions when you want a quick, visual way to control filter effects.

• Use DAX Measures when you need a flexible, formula-based approach to ignore filters on certain columns.

Try these methods in your Power BI reports and choose the best one based on your requirements. 🚀

 

Best Regards

Anmol Malviya

Sr. Data Analyst | Addend Analytics