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

Be one of the first to start using Fabric Databases. View on-demand sessions with database experts and the Microsoft product team to learn just how easy it is to get started. Watch now

Reply
alicek
Helper III
Helper III

How to make a slicer into a dropdown menu?

Hi all, 

 

Usually when I need to make a slicer into a drop down, instead of listing all options, I click on the three-dot menu in the corner and it offers me the option. However, it is not offering me that option anymore. 

 

Another post saying "you have to have the Header" feature turned on is out-of-date, because Header an oiptions anymore. I have both the Slicer Header and the Visual Header turned on. 

 

alicek_0-1610074067335.png

alicek_2-1610074092859.png

 

Does anyone know what could have caused this?

 

Thank you!

 

1 ACCEPTED SOLUTION
amitchandak
Super User
Super User

@alicek , There should be small down arrow below three dots. That will have option

 

Slicer Down arrow.png

Join us as experts from around the world come together to shape the future of data and AI!
At the Microsoft Analytics Community Conference, global leaders and influential voices are stepping up to share their knowledge and help you master the latest in Microsoft Fabric, Copilot, and Purview.
️ November 12th-14th, 2024
 Online Event
Register Here

View solution in original post

13 REPLIES 13
emrson
New Member

emrson_0-1728945466229.png

what about when there are no 'options' in slicer settings?

KaiPonte
Helper I
Helper I

Does anyone have an answer? This is now different.  I get a little tool tip that says, "this setting has moved. To change the slicer style, select Format > Slicer settings > Options > Style."

 

KaiPonte_0-1698082489380.png

 

 

However, there is no such menu under Format. I only have "interactions" and "arrange"

 

KaiPonte_1-1698082580629.png

 

 

Help?

 

Huajun_0-1702257694605.png

 

Thank you all!  I am still getting used to the - in my opinion - confusing UI of PowerBI desktop.  I realized the settings are in teh Visualzations section.

 

  Screenshot 2023-12-12 150252.png

The UI is completely awful!

Anonymous
Not applicable

Look for the three dots on the slicer and click on the Show as a table option.

You'll see another three options on the top right of this new page.  There are two icons under the three options: the Clear Selection and Select the type of Slicer options.  This icon shows a list of slicer types.  

Good luck.

Anonymous
Not applicable

To switch on the slicer header, go to Format Visual in the Visualisations section and look for the Slicer header option.  Switch it on if it is off.

powerfuj
New Member

Yes it is the little down arrow that is difficult to see. The arrow is associated with the Slicer Header.

So you also need to have Slicer Header turned ON

If the Slicer Header is OFF you will not see the little down arrow

(I've just spent way too long figuring this out!)

Super helpful tip - thanks.  

alicek
Helper III
Helper III

Wow, of course. It was so small on my screen I didn't see it. Thanks to you both!

amitchandak
Super User
Super User

@alicek , There should be small down arrow below three dots. That will have option

 

Slicer Down arrow.png

Join us as experts from around the world come together to shape the future of data and AI!
At the Microsoft Analytics Community Conference, global leaders and influential voices are stepping up to share their knowledge and help you master the latest in Microsoft Fabric, Copilot, and Purview.
️ November 12th-14th, 2024
 Online Event
Register Here
pranit828
Community Champion
Community Champion

Hi @alicek 
You have to click on the below icon to get it. 

pranit828_0-1610075794517.png

Select the slicer and hover over it. This icon will appear.

 





PBI_SuperUser_Rank@1x.png


Hope it resolves your issue? 
Did I answer your question? Mark my post as a solution!

Appreciate your Kudos, Press the thumbs up button!!
Linkedin Profile
Anonymous
Not applicable

Thank you so much!! I have been trying to figure this out and going nuts!!! You cannot see the darn carrot until you hover and then it blends in with the white background. Hopefully they will make this more apparent in the future.

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

Dec Fabric Community Survey

We want your feedback!

Your insights matter. That’s why we created a quick survey to learn about your experience finding answers to technical questions.

ArunFabCon

Microsoft Fabric Community Conference 2025

Arun Ulag shares exciting details about the Microsoft Fabric Conference 2025, which will be held in Las Vegas, NV.

December 2024

A Year in Review - December 2024

Find out what content was popular in the Fabric community during 2024.