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