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
In Power BI, I created a Slicer. The Slicer is a list of departments. I tried to click the down-arrow to change the slicer to a dropdown but that option is not there. List is not there either. Instead, I get an error "This setting has moved. To change the slicker style, select Format >Slicer settings > Options > Style." So I went to Format, but Slicer settings is not there. How do I fix my slicer to allow for a drop-down menu?
Solved! Go to Solution.
Hi, so you dont see this? Slicer settings -Style? Under style are all the options
Installing the latest version of Power BI desktop might help
Here's the screenshot from June 2023 version of Power BI wherein both Vertical List and Dropdown optons are available in Slicer settings
Here's the screenshot from June 2023 version of Power BI wherein both Vertical List and Dropdown optons are available in Slicer settings
Hi, have this problem been solved? I have the same case where 'Slicer settings' is not available and wonder where I can find it? Thanks
Here's the screenshot from June 2023 version of Power BI wherein both Vertical List and Dropdown optons are available in Slicer settings
Installing the latest version of Power BI desktop might help
Hi, so you dont see this? Slicer settings -Style? Under style are all the options
for me the solution was to copy the old slicer visual from an old version of power bi (Version: 2.110.1161.0 64-bit (October 2022)), then the dropdown option automatically available
you can download the old versions of power bi from this link https://zenatti.net/2022/10/09/power-bi-2022-previous-versions/
No I do not see that options section. And I just installed the latest version October 2024.
Thanks, I had the same problem today while doing a youtube beginners class. your screenshot helped me find it.
I do not see the dropdown option either... and I am a Microsoft Power BI license holding and I have an E3 subscription to MS 365
I am not seeing the same thing as yours. I see the Slicer settings but I don't see the Options. Please see the screenshot.
Hello,
I feel that you have selected the new Button Slicer. Instead , select the normal slicer as shown below :
This is the reply that helped me.
I downloaded and subscribed to Power BI yesterday and was confounded by not being able to see the dropdown option. And, the slicer I selected had the lightening bolt.
This morning, the lightening bolt option is done. I have created a new slicer, and the dropdown option is available to me!
Thank you so much @Padycosmos , you really helped alot , i have seen where the problem is.
Wow! You are absolutely correct. Thank you so much!
This is it! They really should update their warning of how to update it. It's June 2023 and it still shows to go to a menu that doesn't exist.
Here's the screenshot from June 2023 version of Power BI wherein both Vertical List and Dropdown optons are available in Slicer settings
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
User | Count |
---|---|
90 | |
90 | |
85 | |
73 | |
49 |
User | Count |
---|---|
167 | |
147 | |
92 | |
70 | |
58 |