Forum Discussion

cesc08's avatar
cesc08
Frequent Visitor
9 years ago

Geolocation standard ISO 3166-2 integration with ESRI Map?

Hi there, I was wondering if anyone here has tried to map information for deeper administrative levels than countries with the Esri Visual in pBI. I'm trying to visualize some data for diferent reg...
cesc08's avatar
cesc08
Frequent Visitor
9 years ago

Hi Angelina,

 

Thank you for your efforts.

 

For my scenario I imported the ISO 3166-2 codes for Spain's political subdivisions into PowerBI from wikipedia (https://en.wikipedia.org/wiki/ISO_3166-2:ES). Afterwards I simply tried mapping the codes to State/Province or County and plotting them into the maps, where I got the issue I was mentioning. As an example ES-AR was plotted in the Netherlands...

 

Thanks again for your help!

 

Cesc

  • v-huizhn-msft's avatar
    v-huizhn-msft
    Microsoft Employee
    9 years ago

    Hi cesc08,

    You use the [code] column in Provinces[edit] table? And where field you put?

    Best Regards,
    Angelia

    • cesc08's avatar
      cesc08
      Frequent Visitor
      9 years ago

      Hi v-huizhn-msft,

       

      Yes, I used the [Code] column, and tried both tables --Provinces and Autonomous Communities--. I placed the [Code] into the Location field of the ESRI visualization. I also tried using the [Subdivision Name] column, but also delivered poor results.

       

      Thanks again!

       

      • v-huizhn-msft's avatar
        v-huizhn-msft
        Microsoft Employee
        9 years ago

        Hi cesc08,

        Could you please share a screenshot for further analysis?

        Thanks,
        Angelia