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

Calling all Data Engineers! Fabric Data Engineer (Exam DP-700) live sessions are back! Starting October 16th. Sign up.

Reply
JSmith912
New Contributor II

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
New Contributor III

(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
gdelpuenteCinec
New Contributor III

(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

 

JSmith912
New Contributor II

That worked thank you

Helpful resources

Announcements
Users online (27)