Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

dropdown filter keeps changing

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

ResolvedVersion 365

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.

 

Training courses

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
What does 'Resolved' mean?

Any suggestions, questions or comments? Please post in the Improve the forum thread.

Power BI tip:

Data Cleaning and Transformation

Ensure your data is clean and well-structured before importing it into Power BI. Use Power Query Editor to clean and transform your data. This tool allows you to perform various operations like filtering, merging, and reshaping data, ensuring it's in the right format for analysis.

View all Power BI hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.09 secs.