Forum Discussion
Alexandra_B
Helper III
Helper IIISlicer to create a dynamic visual
HELP please! How can I create a dynamic visual with the details from kWh after tech and have toggles in a slicer column 4 (LED/Controls, Refrig Opt, etc)? I would like to have two visuals, a sta...
I'd start by taking your second table in power query (transform data), select the category column and then use unpivot other columns. Should make it work easier with a single slicer.
Not 100% what your desired output is but hoping that will get you started.
bcdobbs
Community Champion
Community ChampionI'd start by taking your second table in power query (transform data), select the category column and then use unpivot other columns. Should make it work easier with a single slicer.
Not 100% what your desired output is but hoping that will get you started.
Alexandra_BThank you again, that`s exactly what I was looking for! 👏