Solved: Slicer to create a dynamic visual

Alexandra_B · ‎08-09-2022

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 · ‎08-10-2022

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.

Ben Dobbs

LinkedIn | Twitter | Blog

Did I answer your question? Mark my post as a solution! This will help others on the forum!
Appreciate your Kudos!!

View solution in original post

bcdobbs · ‎08-10-2022

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.

Ben Dobbs

LinkedIn | Twitter | Blog

Did I answer your question? Mark my post as a solution! This will help others on the forum!
Appreciate your Kudos!!