March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.
Register NowGet certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now
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.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.
Check out the November 2024 Power BI update to learn about new features.
User | Count |
---|---|
116 | |
85 | |
79 | |
64 | |
59 |
User | Count |
---|---|
140 | |
122 | |
105 | |
94 | |
90 |