Forum Discussion
Helper IIHave a Visual not impacted by the page level filter
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
Community ChampionAlexGurovich - 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.
Page level filter will impact on whole page.
You need to add visual level filter for all else you can create seperate page for which you don't want filter.
Thanks
Pravin