Forum Discussion
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...
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] )
Best Regards,
Dale
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)...