Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hello,
In the context of my work, I want to put the French cities on a map chart, my problem is that power bi places French cities around the world because normally the same city name can exist in several countries
how can we force power-bi desktop to take just french cities ? there is a code that i should respect ?
ps : i'm using an oline connexion and i dan't change the field category
Solved! Go to Solution.
hi, @Anonymous
Just use Expand all fields at once instead of Drill down in the map visual.
https://docs.microsoft.com/en-us/power-bi/consumer/end-user-drill#expand-all-fields-at-once
Regards,
Lin
hi, @Anonymous
Just add country column:
Country = "France"
Then darg into the highest level in the City
Now expand the visual.
Result:
And I also filter the city.
Regards,
Lin
thank you @v-lili6-msft for the time you took to answer my question, in fact I tried this solution before writing my question and it did not work for me (it may be a problem of vesrion power bi ? i have the May 2019 version)
this is what i get when i drill down to city
hi, @Anonymous
Just use Expand all fields at once instead of Drill down in the map visual.
https://docs.microsoft.com/en-us/power-bi/consumer/end-user-drill#expand-all-fields-at-once
Regards,
Lin
thank you very much @v-lili6-msft for the time spent simulating my problem. Indeed I followed your demonsttation and it solved the problem
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
97 | |
96 | |
81 | |
74 | |
66 |
User | Count |
---|---|
129 | |
106 | |
106 | |
86 | |
72 |