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

To celebrate FabCon Vienna, we are offering 50% off select exams. Ends October 3rd. Request your discount 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
September Power BI Update Carousel

Power BI Monthly Update - September 2025

Check out the September 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.

Top Solution Authors
Top Kudoed Authors