https://community.fabric.microsoft.com/t5/Custom-Visuals-Development/Slicers-sorted-by-column/m-p/3863756#M9514 <P><SPAN>I have a dropdown slider, and I can't seem to get it to display the information I'm looking for. Would very much appreciate anyone's input.</SPAN><BR /><BR /><SPAN>I would like it to display the total idle downtime for each month.</SPAN></P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="1.PNG" style="width: 400px;"><img src="https://community.fabric.microsoft.com/t5/image/serverpage/image-id/1084733iA667512FEC41DF7E/image-size/medium?v=v2&amp;px=400" role="button" title="1.PNG" alt="1.PNG" /></span></P><P><SPAN>I would like the dropdown slider to display each of the above fields. However, when I try to put them into the slicer, I get the result below.</SPAN></P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="2.PNG" style="width: 400px;"><img src="https://community.fabric.microsoft.com/t5/image/serverpage/image-id/1084735iE8455703F512CEC6/image-size/medium?v=v2&amp;px=400" role="button" title="2.PNG" alt="2.PNG" /></span></P><P> <BR /><SPAN>I'm very new to Power BI, so please excuse me if it's an easy fix. I just can't find a solution anywhere. Thanks.</SPAN></P> Wed, 24 Apr 2024 01:20:57 GMT JSmith912 2024-04-24T01:20:57Z https://community.fabric.microsoft.com/t5/Custom-Visuals-Development/Slicers-sorted-by-column/m-p/3863756#M9514 <P><SPAN>I have a dropdown slider, and I can't seem to get it to display the information I'm looking for. Would very much appreciate anyone's input.</SPAN><BR /><BR /><SPAN>I would like it to display the total idle downtime for each month.</SPAN></P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="1.PNG" style="width: 400px;"><img src="https://community.fabric.microsoft.com/t5/image/serverpage/image-id/1084733iA667512FEC41DF7E/image-size/medium?v=v2&amp;px=400" role="button" title="1.PNG" alt="1.PNG" /></span></P><P><SPAN>I would like the dropdown slider to display each of the above fields. However, when I try to put them into the slicer, I get the result below.</SPAN></P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="2.PNG" style="width: 400px;"><img src="https://community.fabric.microsoft.com/t5/image/serverpage/image-id/1084735iE8455703F512CEC6/image-size/medium?v=v2&amp;px=400" role="button" title="2.PNG" alt="2.PNG" /></span></P><P> <BR /><SPAN>I'm very new to Power BI, so please excuse me if it's an easy fix. I just can't find a solution anywhere. Thanks.</SPAN></P> Wed, 24 Apr 2024 01:20:57 GMT https://community.fabric.microsoft.com/t5/Custom-Visuals-Development/Slicers-sorted-by-column/m-p/3863756#M9514 JSmith912 2024-04-24T01:20:57Z https://community.fabric.microsoft.com/t5/Custom-Visuals-Development/Slicers-sorted-by-column/m-p/3864765#M9518 <P>(Wrong section for the topic )<BR />you should change the data<BR />using Unpivot table</P><P>go to transform data&nbsp;</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="gdelpuenteCinec_0-1713948289769.png" style="width: 400px;"><img src="https://community.fabric.microsoft.com/t5/image/serverpage/image-id/1085107i56E5D095B6D99204/image-size/medium?v=v2&amp;px=400" role="button" title="gdelpuenteCinec_0-1713948289769.png" alt="gdelpuenteCinec_0-1713948289769.png" /></span></P><P>&nbsp;</P><P>highlights the columns with data by month<BR />and click on Unpivot table</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="gdelpuenteCinec_1-1713948306348.png" style="width: 400px;"><img src="https://community.fabric.microsoft.com/t5/image/serverpage/image-id/1085108i3B8EB6F436190E5F/image-size/medium?v=v2&amp;px=400" role="button" title="gdelpuenteCinec_1-1713948306348.png" alt="gdelpuenteCinec_1-1713948306348.png" /></span></P><P>&nbsp;</P><P>you can now use the Attribute column in the filter</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="gdelpuenteCinec_2-1713948330885.png" style="width: 400px;"><img src="https://community.fabric.microsoft.com/t5/image/serverpage/image-id/1085110iDA2DB83BB6D75C94/image-size/medium?v=v2&amp;px=400" role="button" title="gdelpuenteCinec_2-1713948330885.png" alt="gdelpuenteCinec_2-1713948330885.png" /></span></P><P>&nbsp;</P> Wed, 24 Apr 2024 08:46:39 GMT https://community.fabric.microsoft.com/t5/Custom-Visuals-Development/Slicers-sorted-by-column/m-p/3864765#M9518 gdelpuenteCinec 2024-04-24T08:46:39Z https://community.fabric.microsoft.com/t5/Custom-Visuals-Development/Slicers-sorted-by-column/m-p/3869360#M9534 <P>That worked thank you</P> Thu, 25 Apr 2024 21:31:19 GMT https://community.fabric.microsoft.com/t5/Custom-Visuals-Development/Slicers-sorted-by-column/m-p/3869360#M9534 JSmith912 2024-04-25T21:31:19Z