Forum Discussion

RENEALVAREZM's avatar
RENEALVAREZM
Frequent Visitor
2 years ago

Location hierarchy issue on map visuals

Hello Power BI gurus, Apologies if this is already answsered but I couldn't find the specific issue I'm having.  I have a table with geographic locations (country, province, city, zip code, address...
Need Help
lbendlin's avatar
lbendlin
Super User
2 years ago

For ambiguous locations (there are probably hundreds of "Pueblo Blanco" in the world) you need to help the geocoders by indicating the category of each of your fields.

 

For good measure, add an ISO country code column to your data.

  • RENEALVAREZM's avatar
    RENEALVAREZM
    Frequent Visitor
    2 years ago

    Hello lbendlin, if you take a look at the screenshots, you can see that the Country (Pais), Province and City are part of the hierarchy and should be preserved while you drill-down.

    This does not happen with the regular map visual but looks like the Azure Map has some kind of bug that causes the hierarchy selection not being preserved.

    I know I'm doing it correctly because it works on the regular Map visual but on Azure Maps does not work.

    • lbendlin's avatar
      lbendlin
      Super User
      2 years ago

      Have you specified the category for your columns as I suggested?

      • RENEALVAREZM's avatar
        RENEALVAREZM
        Frequent Visitor
        2 years ago

        Yes. All columns are categorized to their respective data type (country, city, address, postal code...).