Forum Discussion
Resolver IIIAvoid filter to apply in one visual
Hi, everyone
I have tried that only one visual in the page will be not affected by a filter page. The field is 'Invoice Creation Date'.
The problem is when I create the line graph. I use 'Invoice creation date' as axis, and obviously it is only show values of the filter 'Invoice Creation Date'.
I have tried using DAX, but the result is the same.
¿Does anyone knows any idea?
Thanks in advance,
hi Angel
If you want to avoid a slicer filter to apply in one visual, you could edit inrteractions for this visual.
If you want to avoid page level filter (filter on this page) filter to apply in one visual, this could not achieve in power bi for now, you have to set visual level filter for each visual.
Regards,
Lin
5 Replies
- Pragati11
Super User
Hi Angel ,
Not sure if you tried looking for the solution in existing threads. One of the thread I found is:
https://community.powerbi.com/t5/Desktop/How-to-exclude-one-visual-from-page-filters/td-p/664515
If this helps and resolves the issue, appreciate a Kudos and mark it as a Solution! 🙂
Thanks,
Pragati
v-lili6-msftCommunity Support
hi Angel
If you want to avoid a slicer filter to apply in one visual, you could edit inrteractions for this visual.
If you want to avoid page level filter (filter on this page) filter to apply in one visual, this could not achieve in power bi for now, you have to set visual level filter for each visual.
Regards,
Lin
- maulopez
Advocate I
Here's what I did for this scenario. Say you have [Measure 1] being used in a certain visual and 'Table X'[Column Y] is being used as a filter in the Filters Pane. Just make a new measure like this:
Measure 2 = CALCULATE( [Measure 1], REMOVEFILTERS('Table X'[Column Y]))
and use [Measure 2], it won't be filtered by 'Table X'[Column Y].
Or alternatively, "block" the whole 'Table X' from filtering in [Measure 2], like this:
Measure 2 = CALCULATE( [Measure 1], REMOVEFILTERS('Table X'))
Hope this helps.
