Forum Discussion
Solved
Slicer 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.
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.
Thank you again, that`s exactly what I was looking for! 👏