https://community.fabric.microsoft.com/t5/Custom-Visuals-Development/Slicer-to-create-a-dynamic-visual/m-p/2690714#M4816 <P>HELP please!</P><P>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)?</P><P>&nbsp;</P><P>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.</P><P>&nbsp;</P><P>Many thanks.</P><P>&nbsp;</P><P><span class="lia-inline-image-display-wrapper lia-image-align-center" image-alt="tech.JPG" style="width: 865px;"><img src="https://community.fabric.microsoft.com/t5/image/serverpage/image-id/762658i4F4F7DB211E4409E/image-size/large?v=v2&amp;px=999" role="button" title="tech.JPG" alt="tech.JPG" /></span></P><P>&nbsp;</P> Wed, 10 Aug 2022 11:17:11 GMT Alexandra_B 2022-08-10T11:17:11Z https://community.fabric.microsoft.com/t5/Custom-Visuals-Development/Slicer-to-create-a-dynamic-visual/m-p/2690714#M4816 <P>HELP please!</P><P>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)?</P><P>&nbsp;</P><P>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.</P><P>&nbsp;</P><P>Many thanks.</P><P>&nbsp;</P><P><span class="lia-inline-image-display-wrapper lia-image-align-center" image-alt="tech.JPG" style="width: 865px;"><img src="https://community.fabric.microsoft.com/t5/image/serverpage/image-id/762658i4F4F7DB211E4409E/image-size/large?v=v2&amp;px=999" role="button" title="tech.JPG" alt="tech.JPG" /></span></P><P>&nbsp;</P> Wed, 10 Aug 2022 11:17:11 GMT https://community.fabric.microsoft.com/t5/Custom-Visuals-Development/Slicer-to-create-a-dynamic-visual/m-p/2690714#M4816 Alexandra_B 2022-08-10T11:17:11Z https://community.fabric.microsoft.com/t5/Custom-Visuals-Development/Slicer-to-create-a-dynamic-visual/m-p/2692986#M4837 <P>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.</P> <P>&nbsp;</P> <P>Not 100% what your desired output is but hoping that will get you started.</P> Wed, 10 Aug 2022 15:38:33 GMT https://community.fabric.microsoft.com/t5/Custom-Visuals-Development/Slicer-to-create-a-dynamic-visual/m-p/2692986#M4837 bcdobbs 2022-08-10T15:38:33Z https://community.fabric.microsoft.com/t5/Custom-Visuals-Development/Slicer-to-create-a-dynamic-visual/m-p/2693116#M4838 <P>Thank you again, that`s exactly what I was looking for!&nbsp;<span class="lia-unicode-emoji" title=":clapping_hands:">👏</span></P><P>&nbsp;</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="tech.installed.JPG" style="width: 999px;"><img src="https://community.fabric.microsoft.com/t5/image/serverpage/image-id/763342i36C0ACC8F29C50EC/image-size/large?v=v2&amp;px=999" role="button" title="tech.installed.JPG" alt="tech.installed.JPG" /></span></P> Wed, 10 Aug 2022 16:32:43 GMT https://community.fabric.microsoft.com/t5/Custom-Visuals-Development/Slicer-to-create-a-dynamic-visual/m-p/2693116#M4838 Alexandra_B 2022-08-10T16:32:43Z