Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi All,
I need a help.My data is like this. i need to have slicer with contains "Green ,Yellow,Red. so when i select Green it shows only the Green rated items. please help
product | jan rating | feb rating | march rating |
Abc | Green | Green | Yellow |
Abc | Yellow | Red | Red |
sdc | Green | red | yellow |
Hey,
It's a bit of a complex apporach but there's a intresting soultuion here that might be worth checking out
Solved: Re: How to make a slicer to filter for multiple co... - Microsoft Power BI Community
Please let me know if this is of any help or if you would like any additional support?
Many Thanks
Ben
Hi,
you could unpivot the columns in power query so that all the values are in the same field and then use the slicer on that value field. If you need the data in the same format, you could duplicate the table, then unpivot the new tabe and join the tables in model view.
If I answered your question, please mark my post as solution, Appreciate your Kudos 👍
User | Count |
---|---|
98 | |
91 | |
84 | |
71 | |
67 |
User | Count |
---|---|
114 | |
103 | |
100 | |
72 | |
64 |