Power bi slicer

[Ashik008]

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

[cursed]

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

[DOLEARY85]

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 👍