Forum Discussion
Stop Page Level Filter From Applying to One Visual
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?
Thanks!!
we're not understanding;
my suggestion is to establish the value at the table level. this will rerun at each data refresh.
for instance if you create a new calculated table - that is the Sum of X. that stand alone figure/value, put into a visual, will not be affected by filtering of other visuals on the same page.
12 Replies
One solution is establishing the underlying data set (for that visual alone). For instance if I create Table with 1 row 1 field having the value 10 - - - and then make a card visual for that data. It won't matter if the page filter is by State or by Week - it doesn't affect or apply to that card visual's value which will always show 10.
I am a little out of date on all the PBI release updates as to whether there is now a feature in the visual level to exclude from page filters. While there is an exclude option for interaction between visuals on the same page - I don't remember for the page filtering. Perhaps you could establish the same affect using the visual interaction and not rely on a page filter - and then exclude that visual from interaction.
CahabaData That wouldn't work for me.
Using an example, I would like to whole page to be filtered by today's date but I would like this one chart to show data from the beginning of time to today's date.
Does that make sense?
sure it makes sense - and the first half of my post will do the trick, assuming there is today no exclude feature for page level filters
The link below has more generic solution to the problem,
https://community.powerbi.com/t5/Desktop/Stop-filtering-of-one-visualisation/td-p/10866
