cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted

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

Accepted Solutions
Highlighted
Frequent Visitor

Re: Issue: Slicer automatically changes type from Dropdown to List

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

11 REPLIES 11
Highlighted
Super User IV
Super User IV

Re: Issue: Slicer automatically changes type from Dropdown to List

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


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

Putting square pegs in round holes since 1972.

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!




Highlighted
Frequent Visitor

Re: Issue: Slicer automatically changes type from Dropdown to List

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.

Highlighted
Super User IV
Super User IV

Re: Issue: Slicer automatically changes type from Dropdown to List

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".


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

Putting square pegs in round holes since 1972.

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!




Highlighted
Frequent Visitor

Re: Issue: Slicer automatically changes type from Dropdown to List

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

Highlighted
Frequent Visitor

Re: Issue: Slicer automatically changes type from Dropdown to List

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

Highlighted

Re: Issue: Slicer automatically changes type from Dropdown to List

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

Highlighted
Frequent Visitor

Re: Issue: Slicer automatically changes type from Dropdown to List

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

Highlighted
Regular Visitor

Re: Issue: Slicer automatically changes type from Dropdown to List

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.

Regular Visitor

Re: Issue: Slicer automatically changes type from Dropdown to List

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.

Helpful resources

Announcements
May 2020 Community Highlights

May 2020 Community Highlights

It’s time for another PBI Community recap!

Community Blog

Community Blog

Visit our Community Blog for articles, guides, and information created by fellow community members.

Using the Community

Using the Community

Need help with the Power BI Community? Our 'Using the Community' support articles are a great place to start.

Galleries

Galleries

Looking for inspiration on how to present your data? Need instructional videos? Check out our Galleries!

Top Solution Authors