Avoid filter to apply in one visual

[Angel]

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,

[maulopez]

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.

[v-lili6-msft · Accepted solution]

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

[Pragati11]

Hi @Angel ,

Can you please elaborate on your query with some screenshots?

Do you mean how to disable Page level filters on a visual?

Thanks,

Pragati

[Angel]

Hi @Pragati11 

It means disable page level filters on a visual.  Something similar when slicers are used and you can avoid one visual will be affected by the slicer...

Thanks,

[Pragati11]

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