Forum Discussion
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 static one with the details Category and kWh w/o tech and a dynamic visual with Category and kWh after tech , and to be able to change it using a slicer.
Many thanks.
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.
2 Replies
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! 👏
