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

The Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.

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
Feb2025 Sticker Challenge

Join our Community Sticker Challenge 2025

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!

Jan NL Carousel

Fabric Community Update - January 2025

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