March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early bird discount ends December 31.
Register NowBe 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
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.
Does anyone know what could have caused this?
Thank you!
Solved! Go to Solution.
@alicek , There should be small down arrow below three dots. That will have option
what about when there are no 'options' in slicer settings?
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."
However, there is no such menu under Format. I only have "interactions" and "arrange"
Help?
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.
The UI is completely awful!
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.
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.
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.
Wow, of course. It was so small on my screen I didn't see it. Thanks to you both!
@alicek , There should be small down arrow below three dots. That will have option
Hi @alicek
You have to click on the below icon to get it.
Select the slicer and hover over it. This icon will appear.
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 |
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.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
Your insights matter. That’s why we created a quick survey to learn about your experience finding answers to technical questions.
Arun Ulag shares exciting details about the Microsoft Fabric Conference 2025, which will be held in Las Vegas, NV.
User | Count |
---|---|
119 | |
88 | |
73 | |
67 | |
49 |
User | Count |
---|---|
199 | |
140 | |
96 | |
77 | |
68 |