Forum Discussion

Angel's avatar
Angel
Icon for Resolver III rankResolver III
6 years ago
Solved

Avoid 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 'Inv...
Need Help
  • v-lili6-msft's avatar
    v-lili6-msft
    6 years ago

    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's avatar
maulopez
Icon for Advocate I rankAdvocate I
4 years ago

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.