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.
Hi all,
I'm trying to throw together a a simple map, but I'm having issues getting it to show the place names correctly. I'm taken a simple csv file with three headings: Name, Latitude, Longitude. Latitude and Longitude both seem to be working fine, with the dot appearing where they should. But when I add in Names (to the Legend section), Power BI shows them all in all locations in a mini pie chart form (screenshot below).
Here's the barebones dataset I'm using to test this out:
Name Longitute Latitude Paris 2.343179 48.86206 London -0.102216 51.51786 Berlin 13.40233 52.50141 Madrid -3.705769 40.41792 Dublin -6.261357 53.34379
Has anybody any ideas on why this is happening and how I can work around it?
Solved! Go to Solution.
@dvotf make sure you also drop name field onto size section of the map visual and set it as Count of Name, it should then appear back as normal.
Hi @dvotf,
Alternatively, you can drag Name to Location, set the aggregate for Latitude and Longitude to Average in your scenario. Below is the relevant screenshot.
There is also an article about tips for creating Map in Power BI for your reference.
https://powerbi.microsoft.com/en-us/documentation/powerbi-service-tips-and-tricks-for-power-bi-map-v...
Thanks,
Lydia Zhang
Hi @dvotf,
Alternatively, you can drag Name to Location, set the aggregate for Latitude and Longitude to Average in your scenario. Below is the relevant screenshot.
There is also an article about tips for creating Map in Power BI for your reference.
https://powerbi.microsoft.com/en-us/documentation/powerbi-service-tips-and-tricks-for-power-bi-map-v...
Thanks,
Lydia Zhang
@dvotf make sure you also drop name field onto size section of the map visual and set it as Count of Name, it should then appear back as normal.
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 |
---|---|
109 | |
99 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
102 | |
87 | |
64 |