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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Advocate I
Advocate I

Dropdown Slicer Option Missing?



I've just downloaded the November update.  I immediately went to use the new dropdown slicer option (great new feature!!) and don't see it available?  Clicking the 'More Options' ellipsis in the slicer object doesn't show it (and yes I've provided the object with data values).  This occurs both in an existing report and a new report.


My PowerBI Desktop version is 2.41.4581.361 64-bit (November, 2016) ... so I believe I have the correct version running.  Does this option need to be turned on somewhere?

Advocate I
Advocate I

Ah!  Found that the Header has to be ON in order for the Dropdown option to show.  🙂

View solution in original post

Regular Visitor

I am unable to find the dropdown option. can anyone helpScreenshot (265).png 

New Member

That solves it when your in edit mode but if your viewing in desktop or via a web link it doesn't feature. What's frustrating is that the 'Clear all selections' option remains which sits beside the 'Select the type of slicer'. Is that just a limitation of PBI?

Helper I
Helper I

UPDATE: nevermind! it's the dropdown icon " arrow down"  I missed


I'm still not see-ing it...

Headers are on... but still no drop down option from the elipsis at the right corner






How to remove the white space( below all applicable values) shown from the filter value? refrence the blank white space below value 6 on the below image.



Advocate I
Advocate I

Ah!  Found that the Header has to be ON in order for the Dropdown option to show.  🙂

That fixed my problem...  But how infuriating that it's hidden like that five years later!  

THANK you! I would never have found this on my own. Unbelievably stupid design, I had my header switched off, using Title instead..

Thanks buddy for this hint. I got drop down option from right hand corner list.

Not applicable

Just to finesse the point a little:


If you turn off Header before selecting Dropdown, then you can't select Dropdown.

However, if you select Dropdown first, then you can still turn off Header.


Not a logical implementation - usability bug.



Definitely a bug; please fix! Irritating.

Hi @USG_Phil,

Glad to hear that the issue is resolved. You can accept your reply as solution, that way, other community members will easily find the solution when they get same issue.

Besides, you can get more details about new features in  the latest verison of Power BI Desktop from the following articles.
What's new in the latest Power BI Desktop update?
Power BI Desktop November Feature Summary

Lydia Zhang

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

July 2024 Power BI Update

Power BI Monthly Update - July 2024

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


Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

Top Solution Authors