Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
Answers provided in the following forum dont work for me: https://community.powerbi.com/t5/Desktop/Stop-Page-Level-Filter-From-Applying-to-One-Visual/m-p/2493...
Solved! Go to Solution.
Interactions only work with the slicers as off now. Not with filter pane. Better you have a slicer and use Interactions.
You can also explore these options
https://prologika.com/overwriting-power-bi-filters/
https://community.powerbi.com/t5/Desktop/A-Measure-That-Ignores-Page-Level-Filters/td-p/573128
https://community.powerbi.com/t5/Desktop/DAX-formula-to-ignore-page-filter/td-p/366501
@AlexGurovich - So this is going to depend on where your issue lies. If the filter is impacting a value that you do not want impacted, then you are going to write a measure that utilizes ALL, ALLEXCEPT or REMOVEFILTERS in order to remove the page level filter from the calculation.
Now, if your filter impacts something like an x-axis, for example, then you are going to want to create a table for that x-axis. You would do this by creating a new table using something like DISTINCT on the column used in that x-axis. Once you have that table, you create a relationship between the two tables and then a similar kind of measure.
Easier to explain with a PBIX, which is attached. Let me know if there is a circumstance that this does not cover.
Interactions only work with the slicers as off now. Not with filter pane. Better you have a slicer and use Interactions.
You can also explore these options
https://prologika.com/overwriting-power-bi-filters/
https://community.powerbi.com/t5/Desktop/A-Measure-That-Ignores-Page-Level-Filters/td-p/573128
https://community.powerbi.com/t5/Desktop/DAX-formula-to-ignore-page-filter/td-p/366501