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

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now

Reply

Issue: Slicer automatically changes type from Dropdown to List

I have a slicers from power BI desktop in which I set to a dropdown type but after publishing it online and embedded it to my page it automatically changes the slicer type to List. I want my slicers to be in a dropdown type and I don't want the BI to change it automatically to different types. Is there an option setting that I need to change? Please help. Thank you so much.

 

Beforebefore.PNG

After

 

after.PNG

 

1 ACCEPTED SOLUTION
AnatolyYavorsky
Advocate I
Advocate I

Until this matter is fixed by PBI team, you could action as follows in Desktop:

1. Select Dropdown on your slicer
2. Create new bookmark of the page with this dropdown slicer

3. Replace old bookmark with a new one and adjust the setting of all your images, shapes etc linked to the old bookmark

Otherwise, it would seem PBI published report picks up the original version of the slicer with the List rather then Dropdown

Hope this helps

View solution in original post

18 REPLIES 18
fedlov
Advocate II
Advocate II

Goodness I can't believe this is 4 years old and still happening!

 

And by the way this isn't solved.

The solution provided is a workaround but it's happening to me in a sheet that doesn't have any bookmark.

Microsoft has to step up their game here. I'm seeing more and more issues that just shouldn't happen.

Absolutely... updating the bookmark did not work for me, which is frankly quite annoying...

sandy2112
Frequent Visitor

Update Bookmrak worked for me.. Thanks a lot.

silasmeredith
Advocate I
Advocate I

Thank you everyone for the suggested solution (to update bookmarks)! Unfortunately, I have tried this several times, and am still experiencing the bug. Is anyone else still experiencing this, and has anyone found an alternate solution?

I'm having the same issue too, I updated the bookmark severally but it didn't work, It worked after I created another bookmark as advised by @fedlov though.

Keep telling my end users to hit the 'reset to default' button when it happens. 

 

Been an issue since the Hierarchy feature was released this year IMHO

AgustínM
Advocate I
Advocate I

Easier way to manage: Update the slicers in your page, as you wish, and then just Update the Page Bookmark (you don't need to create a new Bookmark!). (It seems the Bookmark keeps the visualizations for the Page at the moment such Bookmark is created or whenever it's afterwards updated.

AgustínM
Advocate I
Advocate I

Easier way to manage: Update the slicers in your page, as you wish, and then just Update the Page Bookmark (you don't need to create a new Bookmark!). (It seems the Bookmark keeps the visualizations for the Page at the moment such Bookmark is created or whenever it's afterwards updated.

It worked perfectly! Thanks a lot!

AnatolyYavorsky
Advocate I
Advocate I

Until this matter is fixed by PBI team, you could action as follows in Desktop:

1. Select Dropdown on your slicer
2. Create new bookmark of the page with this dropdown slicer

3. Replace old bookmark with a new one and adjust the setting of all your images, shapes etc linked to the old bookmark

Otherwise, it would seem PBI published report picks up the original version of the slicer with the List rather then Dropdown

Hope this helps

I know this is old, but this simple trouble shooting check made my life a whole lot easier.  Remake the Shortcut!  thank you!

great.. it works

Thank you so much @AnatolyYavorsky your solution works for me.

You are most welcome @chesterraepined. Glad I could help. 

AnatolyYavorsky
Advocate I
Advocate I

Until this matter is fixed by PBI team, you could action as follows in Desktop:

1. Select Dropdown on your slicer
2. Create new bookmark of the page with this dropdown slicer

3. Replace old bookmark with a new one and adjust the setting of all your images, shapes etc linked to the old bookmark

Otherwise, it would seem PBI published report picks up the original version of the slicer with the List rather then Dropdown

Hope this helps

RJS849
Frequent Visitor

Was this resolved. I am having the same issue. It appeared after I added the bookmarks. Looks like when i click on the bookmark in the bookmark pane, the slicer dropdown changes to list. I think somehow bookmark messes it up.

You could check the Issues forum here:

 

https://community.powerbi.com/t5/Issues/idb-p/Issues

 

And if it is not there, then you could post it. 

 

If you have Pro account you could try to open a support ticket. If you have a Pro account it is free. Go to https://support.powerbi.com. Scroll down and click "CREATE SUPPORT TICKET".


@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
Mastering Power BI 2nd Edition

DAX is easy, CALCULATE makes DAX hard...
Greg_Deckler
Super User
Super User

That seems like a bug to me, I would post this in Issues area.


@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
Mastering Power BI 2nd Edition

DAX is easy, CALCULATE makes DAX hard...

Helpful resources

Announcements
Fabric Community Conference

Microsoft Fabric Community Conference

Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.

February 2024 Update Carousel

Power BI Monthly Update - February 2024

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

Fabric Career Hub

Microsoft Fabric Career Hub

Explore career paths and learn resources in Fabric.

Fabric Partner Community

Microsoft Fabric Partner Community

Engage with the Fabric engineering team, hear of product updates, business opportunities, and resources in the Fabric Partner Community.