98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View Reviews
Forum home » Delegate support and help forum » Microsoft Power BI training and help » Dropdown filter keeps changing to list in published version
Dropdown filter keeps changing to list in published version
Resolved · Low Priority · Version 365
Wed 21 Oct 2020, 14:37Delegate 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:10Delegate 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.
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Power BI tip:Master the Power BI Custom VisualsPower 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. |
