Have a Visual not impacted by the page level filter

[AlexGurovich]

Hi Guys,

 

Is there a way to have a visual not impacted by the page level filter?

 

I have a lot of graphs that need the same filter so I set up a page level filter, but there's one chart that I don't want impacted.

 

Is there any way to set that up?

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...

[Greg_Deckler]

@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.

[Anonymous]

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

[amitchandak · Accepted 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

https://www.pbiusergroup.com/communities/community-home/digestviewer/viewthread?MessageKey=09c108ff-...