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

Get Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request 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
November Power BI Update Carousel

Power BI Monthly Update - November 2025

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

Fabric Data Days Carousel

Fabric Data Days

Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.

Top Solution Authors