Slicer Drop Down Turns Into List When Published

[hanyuwang]

The Customer Name slicer displays fine in Power BI desktop as a dropdown

But when published, it turns into a list. 

Any advise?

[Syndicate_Admin]

Someone has been able to see why this error occurs... the same thing happens to me:

1 On desktop it is as a drop-down menu....

2. When initially published it follows as a drop-down menu....

3. But if I navigate to some marker change to list ......

4. To return to remain as a drop-down menu I have to reload the page ...

[Anonymous]

Try clicking the "Reset to default" button on the top-right of your dashboard when viewed in the web browser. This did the trick for me 🙂 

Konstantinos

[mybarbie9917]

I have the same issue and tried to clear any bookmarks and to refresh the app, but it still doesn't work. I didn't have this issue before. This is definitely a bug. 

The range slicer looks fine in the PBI Desktop and in the report published to a workspace. 

But the range slicer suddenly changed to a list in the app. 

[Anonymous]

The accepted solution did not solve my issues with slicers chaning upon publishing either. Even more odd, after chaning the slicer type in service and saving, they still revert back to drop downs... 

[kriscoupe · Accepted solution]

Hi @hanyuwang,

2 questions/suggestions to look at

1. After publishing have you clicked the refresh button (sometimes the reports are cached in your browser and so don't update to the new report that has been published automatically.

2. Do you have any bookmarks set up that effect that slicer? If you have the display/data ticks and you've set up some bookmarks that effect that slicer then it's possible it will try to revert it to the same type you had it set when the bookmark was established.

Let me know if it helps.

Kris

[In_du]

Press refresh visuals in the published report

[ROKRI]

Hello @kriscoupe 

Glad I found this chain as I'm having the same problem, plus a related one. I have 4 drop drop down slicers - one turns into a list when published, in the other the options disappear. The other two are fine. I followed the two recommended steps but it did not fix the issue (I have no bookmarks and have cleared my cache multiple times). I even double checked the configuration and unset/reset as dropdown but that did not fix it.

I appreciate any additional ideas to resolve.

Thanks,

Russ

[hanyuwang]

Thanks Kris. I don't have bookmarks but it may or may not be a caching issue. It was developed with a dropdown list so I'm not sure how it cached with a list. I left it there for a couple hours and it magically worked. 

Regardless, those are great advises. I appreciate it!

[kriscoupe]

Sometimes these things work like that eh?! At least it's all working now!

Good evening!