Forum Discussion
filtering
Hi. I have a table with 6 metrics which I want to visualize using bar charts. (say Metric1 - Metric6) Those columns have numeric values. Can I make a selection filter so that the user decides to...
Hi.
Those 6 metrics are not in the same column.
I was able to solve by using the unpivot option and creating 2 new columns, one stores the specific metric and the other its value. From there I could easily use it as a filter.
I guess the switch function works as well but I haven't tried it out.
Thank you
See if this thread helps:
https://community.powerbi.com/t5/Desktop/Multiple-Measures-Slicer/m-p/2124649#M785791