Dropdown filter keeps changing to list in published version

Resolved · Low Priority · Version 365

Wed 21 Oct 2020, 14:37 Delegate Valerie said...

Valerie has attended:
Excel Advanced - Formulas & Functions course
Power BI Reporting course

Dropdown filter keeps changing to list in published version

Hi Jens
Enjoyed the course on Monday, and have now created a report.
I have data plotted on a map (using Lats, Longs) although there is also a site name and country in the various data fields.
I would like to be able to filter on country and/or site name, and this works OK in PowerBI desktop, but when I publish the report, the dropdown Country filter changes from a look up to a list. (The Site filter stays as a lookup OK.)
Any ideas?
Thanks,

Val.

Wed 21 Oct 2020, 21:10 Delegate Valerie said...

RE: Dropdown filter keeps changing to list in published version

I have found the solution by googling. It is to do with bookmarks. I deleted the bookmark to this page, and then created a new one, and that solved it.

https://community.powerbi.com/t5/Desktop/Issue-Slicer-automatically-changes-type-from-Dropdown-to-List/td-p/470783

Thanks.

Training courses

	98.7 % recommend us
	More live stats...

Active questions
Advanced/consultancy questions
Today's questions
Unanswered questions
Popular forum topics

Power BI tip:

Master the Power BI Custom Visuals

Power BI offers a variety of custom visuals created by the community and Microsoft. Explore these visuals to enhance your reports and dashboards. Whether it's a custom map, a timeline, or a unique chart type, custom visuals can add significant value to your visualizations.

View all Power BI hints and tips