Forum Discussion

fjcasado's avatar
fjcasado
Regular Visitor
3 years ago

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

 

 

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

 

Thanks!

3 Replies

  • lbendlin's avatar
    lbendlin
    Icon for Super User rankSuper User
    3 years ago

    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".

     

     

    • fjcasado's avatar
      fjcasado
      Regular Visitor
      3 years ago

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

      Greetings.

      • lbendlin's avatar
        lbendlin
        Icon for Super User rankSuper User
        3 years ago

        Please provide sample data that fully covers your issue.