slicer with % range

[manishsalanke]

hi ,community members we have a requirement in that we want to show range of % in slicer .

we have created. a measure for percentages of saleswe wanted to know if we can see the pecentage % range in a slicer so that we can see (for eg-in  range 20-30 how many cities comes .( is it possible to see it in a slicer visual using a mesure.)

[Ahmedx]

1) You need to create a separate table "Rate_tbl" , unrelated to other tables

2) write a measure

Based on your description, I created data to reproduce your scenario. The pbix file is attached in the end.
https://1drv.ms/u/s!AiUZ0Ws7G26Rhjp_7eqbpoU8_xKN?e=L1R35m

[aditya0125]

create grps and then put that into slicer.
or other option is create matric and use selectedvalue and switch dax.without creating any measures