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

Be one of the first to start using Fabric Databases. View on-demand sessions with database experts and the Microsoft product team to learn just how easy it is to get started. Watch now

Reply
OneWithQuestion
Post Prodigy
Post Prodigy

Map: not possible to do country to state hierarchy?

I have a table of locations which include foreign nations.

 

At the country level all seems to work well, I get United States of America, some in France, and some in Japan for example.

 

Then, when I go to drill down to state level, it ignores the parent country and remaps everything by just looking at the state codes.

 

This means that some of the Japanese prefectures get mapped to American states.
JapanInUSA.PNG 

 

I would have expected the map to have seen country first as it is listed country, then state in the data field second all of it together under a location hierarchy

1 ACCEPTED SOLUTION
v-caliao-msft
Microsoft Employee
Microsoft Employee

@OneWithQuestion,

 

For the drill down feature in Map, please refer to the "Use geo-hierarchies so you can drill down to different "levels" of location" on the link below.
https://docs.microsoft.com/en-us/power-bi/power-bi-map-tips-and-tricks

 

Regards,

Charlie Liao

View solution in original post

1 REPLY 1
v-caliao-msft
Microsoft Employee
Microsoft Employee

@OneWithQuestion,

 

For the drill down feature in Map, please refer to the "Use geo-hierarchies so you can drill down to different "levels" of location" on the link below.
https://docs.microsoft.com/en-us/power-bi/power-bi-map-tips-and-tricks

 

Regards,

Charlie Liao

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!

ArunFabCon

Microsoft Fabric Community Conference 2025

Arun Ulag shares exciting details about the Microsoft Fabric Conference 2025, which will be held in Las Vegas, NV.

December 2024

A Year in Review - December 2024

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