Forum Discussion

fhgomezn's avatar
fhgomezn
New Member
8 years ago

Colombia map

I've been having problems with Colombia's filled map, trying to draw the states/provinces. I'm trying adding the whole name of the country and with the 3 letters abreviation, it stills draw some stat...
fhgomezn's avatar
fhgomezn
New Member
8 years ago

Hi, I've been having problems with Colombia's Filled map, PowerBI does not recognized some states:

Amazonas, Colombia or Amazonas, COL

Bolívar, Colombia or Bolívar, COL

Nariño, Colombia or Nariño, COL

Córdoba, Colombia or Córdoba, COL

Guainía, Colombia or Guainía, COL

 

Sometimes it draws them in Argentina, Brazil, Venezuela, USA, Perú or Paraguay. Sometimes it say that it requires more location data. I'm trying with the full name of the country, with the abreviation (COL), merging it with a comma, with space... anything has worked. 

It's very frustrating this situation.

v-jiascu-msft's avatar
v-jiascu-msft
Microsoft Employee
8 years ago

Hi fhgomezn,

 

You can add a calculated column with the formula below. But I made a little change of Guainía. If I change it to Guainia, it will show correctly in the map. I searched the Bing map and Google map. I see both of the two names in both of the maps. I don't know if this is correct. You can check it out in this file.

Column =
IF ( [Department] = "Guainía", "Colombia Guainia", "Colombia " & [Department] )

Colombia_maps

 

 

Best Regards,

Dale

  • fhgomezn's avatar
    fhgomezn
    New Member
    8 years ago

    thanks v-jiascu-msft 

    Do you know why this column transformation and choosing "place" in "data category" option does not work for Colombia Amazonas? That's the last state (frontier wiht Brazil and Perú) and it shows a blank spot there.

    If I choose "state/province" in "data category" with this new column, it place Colombia Amazonas in Perú or Brazil (that countries also have a state named Amazonas)...