Forum Discussion

YunJ's avatar
YunJ
Icon for Post Prodigy rankPost Prodigy
6 years ago
Solved

How to exclude specifically when choosing different values in slicer?

Hi,

 

I'm wondering when Slicer Category="Skincare", I don't want the brands:Perfectdiary and Florasis shown here. But when selecting other Category, they should also show as normal.

 

Thanks

Yun

Need Help
  • v-deddai1-msft's avatar
    v-deddai1-msft
    6 years ago

    Hi YunJ ,

     

    You can create a measure and drag it to table visual filter:

     

    Measure = IF( SELECTEDVALUE([Category]) = "Skincare" &&MAX([Brand]) in{"Perfectdiary","Florasis"} ,0,1)

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

     

    Best Regards,

    Dedmon Dai

  • v-deddai1-msft's avatar
    v-deddai1-msft
    6 years ago

    Hi YunJ ，

     

    Sorry for that  I seem to have made a mistake, you need to change the filter to is 1.

     

    Best Regards,

    Dedmon Dai

9 Replies