Filtering table using slicer

[arif_tsrm]

I have a simple measure, returning % value, ( please see attached) , how can I filter the measure value  using slicer, when I will select 0-25% then only the value within this range will appear others are filter out, similar for 26-50% and so on.measureslicertable visualization

[Ritaf1983 · Accepted solution]

Hi @arif_tsrm 
Please refer to the linked tutorial video.
Your ranges are the "names".

https://www.youtube.com/watch?v=AHiCE1N0XHE

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

[Anonymous · Accepted solution]

Hi  @arif_tsrm ,

Here are the steps you can follow：

1. Create measure.

Flag =
SWITCH(
    TRUE(),
    MAX('Slicer table'[Score%])= "0-25%" && [Score%ForBottomTbl] >=0&&[Score%ForBottomTbl]<=0.25,1,
    MAX('Slicer table'[Score%])= "25-50%" && [Score%ForBottomTbl] >=0.26&&[Score%ForBottomTbl]<=0.5,1,
    MAX('Slicer table'[Score%])= "51-75%" && [Score%ForBottomTbl] >=0.51&&[Score%ForBottomTbl]<=0.75,1,
    MAX('Slicer table'[Score%])= "76 to up" && [Score%ForBottomTbl] >=0.76,1,0)

2. Place [Flag]in Filters, set is=1, apply filter.

3. Result:

Best Regards,

Liu Yang

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

[Ritaf1983 · Accepted solution]

Hi @arif_tsrm 
Please refer to the linked tutorial video.
Your ranges are the "names".

https://www.youtube.com/watch?v=AHiCE1N0XHE

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