Create a Slicer Out of a Measure

[Anonymous]

I have a table of clients and an associated tech rating. I have a measure that calculates a "Rating %" and another measure that categorizes them into percentiles ("Tech Rating Percentile"). I'd like to put the "Tech Rating Percentile" into a slicer that will then impact other visuals... Can I do this?

[gckcmc]

same question as your other....don't use measures for this, build calculated columns would be my advice. 🙂  Maybe better experts know an easy way to do this....

[Anonymous]

It can't be a column because I need the data to be dynamic...

[amitchandak · Accepted solution]

Only few work around 

https://community.powerbi.com/t5/Desktop/Cannot-use-measure-in-slicer/td-p/166909

https://community.powerbi.com/t5/Desktop/Measure-as-Slicer-Workaround/td-p/611781

https://community.powerbi.com/t5/Desktop/Build-a-Slicer-based-on-a-measure/td-p/530718

[Anonymous]

Thanks for these! The second source got me very close, but not quite what I need. I'll keep you all posted if something better comes along, but for now, it's a pretty good work around.