Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!To celebrate FabCon Vienna, we are offering 50% off select exams. Ends October 3rd. Request your discount now.
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.
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
Solved! Go to Solution.
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
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