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

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends September 15. Request your voucher.

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
August Power BI Update Carousel

Power BI Monthly Update - August 2025

Check out the August 2025 Power BI update to learn about new features.

August 2025 community update carousel

Fabric Community Update - August 2025

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