Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
JSmith912
Regular Visitor

Slicers sorted by column

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.

1.PNG

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.

2.PNG


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.

1 ACCEPTED SOLUTION
gdelpuenteCinec
Frequent Visitor

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

go to transform data 

gdelpuenteCinec_0-1713948289769.png

 

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

gdelpuenteCinec_1-1713948306348.png

 

you can now use the Attribute column in the filter

gdelpuenteCinec_2-1713948330885.png

 

View solution in original post

2 REPLIES 2
JSmith912
Regular Visitor

That worked thank you

gdelpuenteCinec
Frequent Visitor

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

go to transform data 

gdelpuenteCinec_0-1713948289769.png

 

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

gdelpuenteCinec_1-1713948306348.png

 

you can now use the Attribute column in the filter

gdelpuenteCinec_2-1713948330885.png

 

Helpful resources

Announcements
PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

Top Solution Authors