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

Don't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.

Reply
RENEALVAREZM
Frequent Visitor

Location hierarchy issue on map visuals

Hello Power BI gurus,

Apologies if this is already answsered but I couldn't find the specific issue I'm having. 

I have a table with geographic locations (country, province, city, zip code, address and even latitude and longitude). All my data is for Spain.

If I use a simple hierarchy: Country / Province / City, at the first level looks correct:

Location issue 1.png

If I expand to the next level (preserving the previous level), all still looks right:Location issue 2.png

But then, if I expand the next level which is City, now I see locations outside the corresponding country and I can't figure out why and how to fix it.

Location issue 3.png

For example, that location that displays over Venezuela, corresponds to a city in Spain.

Location issue 4.png

What am I missing on this scenario?

7 REPLIES 7
lbendlin
Super User
Super User

For ambiguous locations (there are probably hundreds of "Pueblo Blanco" in the world) you need to help the geocoders by indicating the category of each of your fields.

 

lbendlin_0-1696893511303.png

For good measure, add an ISO country code column to your data.

Hello @lbendlin, if you take a look at the screenshots, you can see that the Country (Pais), Province and City are part of the hierarchy and should be preserved while you drill-down.

This does not happen with the regular map visual but looks like the Azure Map has some kind of bug that causes the hierarchy selection not being preserved.

I know I'm doing it correctly because it works on the regular Map visual but on Azure Maps does not work.

Have you specified the category for your columns as I suggested?

Yes. All columns are categorized to their respective data type (country, city, address, postal code...).

Can you post a sample file? 
If you are unsure how to do that please refer to https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-...

Here's a sample file where you can see the issue.

I added just two maps: the regular default map, and an Azure Map with excatly the same hierarchy.

When you get to "City", you'll see that on the left (the regular map), the bubbles are placed correctly, while in the right (the Azure Map) it omits the previous levels.

https://actualsolutions-my.sharepoint.com/:u:/g/personal/rene_actualsolutions_tech/EWPgGsmHe4NAneCPP... 

Map Isue.png

When you get to "City", you'll see that on the left (the regular map), the bubbles are placed correctly, 

Not really,  you still have misplaced locations in the US and Latin America.  

 

You can raise an issue at https://community.fabric.microsoft.com/t5/Issues/idb-p/Issues . If you have a Pro license you can consider raising a Pro ticket at https://admin.powerplatform.microsoft.com/newsupportticket/powerbi

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!

Jan25PBI_Carousel

Power BI Monthly Update - January 2025

Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.

December 2024

A Year in Review - December 2024

Find out what content was popular in the Fabric community during 2024.