Forum Discussion

v-sihou-msft's avatar
v-sihou-msft
Icon for Microsoft Employee rankMicrosoft Employee
8 years ago

mehaboob557

 

If those values "0.1~0.9" and "1.1~1.9" are filtering same column, it's not possible to split them into two slicers. 

 

In this scenario, you can create a bucket column like:

 

Bucket =IF(Table[Column]<1,"0.x","1.x")

Then you can put this bucket column into a slicer. When you select a "bucket", the corresponding values will be cascading filtered in another slicer.

 

Regards,

  • mehaboob557's avatar
    mehaboob557
    Icon for Resolver III rankResolver III
    8 years ago

    Will implement and if it works i will accept your solution.

     

    Thank you so much v-sihou-msft