Legend on map showing all names in all places

[dvotf]

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?

[ankitpatira · Accepted 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.

[v-yuezhe-msft · Accepted solution]

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

[ankitpatira · Accepted 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.