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
fjcasado
Regular Visitor

Map in Power BI using country and city

I'm trying to draw several world cities on a Power BI map. The problem is that there are several cities with the same name in different countries, and I don't know how to limit the city to the correct country. If I use country and then city as a hierarchy it doesn't work

 

fjcasado_0-1666880388388.png

 

Could you tell me if it is possible to correctly identify the city in its corresponding country?

 

Thanks!

3 REPLIES 3
lbendlin
Super User
Super User

Use the field categorization function to help Power BI understand the meaning of each field.  Be careful to use "country"  for your country information, not "county".

 

lbendlin_0-1667958802968.png

 

Thank you very much for your reply. The fields are correctly categorized. I continue with the problem.

Greetings.

Please provide sample data that fully covers your issue.

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