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

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
BryceJones
Frequent Visitor

Need to adjust default amount of options for drop down slicer

Hello,

 

I'm curious if it is possible to increase the default amount of options that available for selection that appears when using a drop down slicer. I'm aiming for something that resembles this in Excel but for a drop down slicer in Power BI: 

 

BryceJones_0-1741189352321.png

Any suggestions is much appreciated.

1 ACCEPTED SOLUTION

Ah, OK, I understand now. Unfortunately, no, I don't think there is a way to get more items to show up for a drop-down slicer like that. The alternative is to use a Vertical List layout, but I suspect that page real estate is an issue.

You can submit an ideal here: Fabric Ideas - Microsoft Fabric Community




Did I answer your question? If so, mark my post as a solution. Also consider helping someone else in the forums!

Proud to be a Super User!





View solution in original post

9 REPLIES 9
ToddChitt
Super User
Super User

>>I am hoping to have more options appear than the default value.<<

What do you mean by "the default value"? As I understand it, you cannot define a default value for a slicer.

Also, are you working with a Report Page, or a DASHBOARD?

Can you show some screenshots with data blurred out for privacy resaons?




Did I answer your question? If so, mark my post as a solution. Also consider helping someone else in the forums!

Proud to be a Super User!





Thank you for responding. Here is  a blurred image. As can be seen 9 automatically appears that can be selected before scrolling. What I hoping to do is expand that number to greater than 9 before the user has to scroll

BryceJones_2-1741196992171.png

 

Ah, OK, I understand now. Unfortunately, no, I don't think there is a way to get more items to show up for a drop-down slicer like that. The alternative is to use a Vertical List layout, but I suspect that page real estate is an issue.

You can submit an ideal here: Fabric Ideas - Microsoft Fabric Community




Did I answer your question? If so, mark my post as a solution. Also consider helping someone else in the forums!

Proud to be a Super User!





This is for a dashboard

ToddChitt
Super User
Super User

The slicer will simply read the DISTINCT values from the field you assign it. Your picture shows 8 values in the slicer, and I assume that more is available via the vertical slider. 

Not sure of the problem you are trying to solve.




Did I answer your question? If so, mark my post as a solution. Also consider helping someone else in the forums!

Proud to be a Super User!





The actual data is not date data and a requirement is to use a drop down slicer

Thank you for your response. The image I included is dummy data. I'm not allowed to share exact data due to company policy. The problem I'm trying to solve is with the drop down in the current dashboard. I am hoping to have more options appear than the default value.

ToddChitt
Super User
Super User

A slicer like you show is just another 'visual' on the page, and as such, can have its own visual level filters applied. Would it suffice if you filtered the available values to be only the years you want?




Did I answer your question? If so, mark my post as a solution. Also consider helping someone else in the forums!

Proud to be a Super User!





Thank you for your response. In this case I'm seeking to increase the amount of values that appears when an end user selects the drop down. For example. Instead of 3 I would want 15-20.

Helpful resources

Announcements
August Power BI Update Carousel

Power BI Monthly Update - August 2025

Check out the August 2025 Power BI update to learn about new features.

August 2025 community update carousel

Fabric Community Update - August 2025

Find out what's new and trending in the Fabric community.

Top Solution Authors