cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
chesterraepined
Helper I
Helper I

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
Frequent Visitor

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

13 REPLIES 13
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?

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
Frequent Visitor

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

great.. it works

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

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

AnatolyYavorsky
Frequent Visitor

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!!!

I have a NEW book! 
DAX Cookbook from Packt
Over 120 DAX Recipes!




Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




Greg_Deckler
Super User IV
Super User IV

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


---------------------------------------

@ me in replies or I'll lose your thread!!!

I have a NEW book! 
DAX Cookbook from Packt
Over 120 DAX Recipes!




Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




Helpful resources

Announcements
MBAS on Demand

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

July 2021 Update 768x460.png

Check it out!

Click here to read more about the July 2021 Updates

Power Query PA Forum 768x460.png

Check it out!

Did you know that you can visit the Power Query Forum in Power BI and now Power Apps

Top Solution Authors
Top Kudoed Authors