Mapping Latitude Longitude Pairs without averaging and also showing label over each point

[wonge7]

Let's say my dataset looks like this

Location Name	Latitude	Longitude
Apple	40.34	-80.1
Orange	45.56	-72.8
Banana	43.23	-79.4
Apple	43.50	-73.45

NOTE: Notice how there is a repeated Location Name "Apple".

If I were to use the Latitude and Longitude columns to plot on a map, it would plot normally but without labels.

Image 1 

But if I were to add the Location Name to the "Location Field" so that I can get labels over my datapoints. It would ask me to "Remove Location to display latitude and longitude pairs. Alternatively, you can also keep Location and set the aggregate for Latitude and Longitude to Average".

Image 2 

If I average my longitude and latitude points. While I can enable Category to show my Location Name as labels, the point it plots would become the halfway point between my two "Apple" coordinate pairs, in other words, in the middle of nowhere. 

Image 3 

(Notice how I lost a data point, and the point's location is almost the halfway point between the previous two "Apple" points).

Does anyone know how I can plot all four points, with all four Location Names showing as Labels over the datapoints (And no, Legends wouldn't work, as my real dataset has hundreds of points and it would be a nightmare to scroll through)

PS. If this is a limitation of mapping latitude/longitude pairs, I also have access to the address of each location.

Thanks,

[Greg_Deckler]

Add an Index column in Power Query?

[wonge7]

Thanks for your reply,

I have added an Index column to my dataset now, but it doesn't seem to affect the results. Could you possibly elaborate on how I'm supposed to use this Index column?

[dax · Accepted solution]

Hi @wonge7 , 

Currently, if you want to show name in label, you need to use "Location". Or you could see it in legend. You could refer to my sample for details.

Best Regards,
Zoe Zhi

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.