topic Re: Slicers sorted by column in Custom Visuals Development Discussion

Slicers sorted by column

JSmith912 — Wed, 24 Apr 2024 01:20:57 GMT

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.

I would like it to display the total idle downtime for each month.

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.

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.

Re: Slicers sorted by column

gdelpuenteCinec — Wed, 24 Apr 2024 08:46:39 GMT

(Wrong section for the topic )
you should change the data
using Unpivot table

go to transform data

highlights the columns with data by month
and click on Unpivot table

you can now use the Attribute column in the filter

Re: Slicers sorted by column

JSmith912 — Thu, 25 Apr 2024 21:31:19 GMT

That worked thank you