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 f...
DOLEARY85
Resident Rockstar
Resident RockstarHi,
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 👍