Get certified for free when you join Fabric Data Days 2026 and dive into Fabric, Power BI, SQL, AI, and other essential data skills.
Join nowJuly 28 - August 9 | Final Round of the Power BI Dataviz World Championships. This is your chance. Learn more
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.
Solved! Go to Solution.
(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
That worked thank you
(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
If you love stickers, then you will definitely want to check out our community sticker challenge, Barcelona edition!
Check out the July 2026 Power BI update to learn about new features.