Slicer to create a dynamic visual

[Alexandra_B]

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.

[bcdobbs · Accepted solution]

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.

[Alexandra_B]

Thank you again, that`s exactly what I was looking for! 👏