Forum Discussion
Power bi slicer
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 |
2 Replies
- DOLEARY85
Resident Rockstar
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 👍
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
