Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Get 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

Reply
dvotf
Frequent Visitor

Legend on map showing all names in all places

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).

 

Screenshot of Power BI rendering

 

 

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?

 

2 ACCEPTED SOLUTIONS
ankitpatira
Community Champion
Community Champion

@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.

View solution in original post

v-yuezhe-msft
Microsoft Employee
Microsoft Employee

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.
111.png

 

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

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

2 REPLIES 2
v-yuezhe-msft
Microsoft Employee
Microsoft Employee

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.
111.png

 

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

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
ankitpatira
Community Champion
Community Champion

@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.

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.

Nov PBI Update Carousel

Power BI Monthly Update - November 2024

Check out the November 2024 Power BI update to learn about new features.

October NL Carousel

Fabric Community Update - October 2024

Find out what's new and trending in the Fabric Community.