Forum Discussion

JSmith912's avatar
JSmith912
Frequent Visitor
2 years ago
Solved

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.

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.

Visuals
  • gdelpuenteCinec's avatar
    gdelpuenteCinec
    2 years ago

    (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

     

2 Replies

  • gdelpuenteCinec's avatar
    gdelpuenteCinec
    Helper I
    2 years ago

    (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