Arg ZIP Code do not detected in map. IF formula or calculated column for Province?

[franorio]

Hello everybody, 

this is some of the raw information my report has. Would like to create a MAP to see the subtotal of sales by region for Argentina.

But Zip codes are not detected. The shipping Provinces are downloaded by letter, for example Province Buenos Aires is letter B, Ciudad Autonoma letter C, Neuquen letter Q. 

How should I do to create a measure or calculated column to say if:

A = Salta

B = Buenos Aires

C = Ciudad Autonoma

...

Q = Neuquen

Z = Santa Cruz

Want to try if Power BI detects Argentinian provinces. But would prefer to detect by ZIP for more precision. Any ideas?

Thanks & Regards

[Sean]

Try plotting the Provinces' names with ArcGIS - seems to work there

I can see they don't plot all correctly in PBI

I suspect some of those Province names may have to be adjusted to plot correctly in the native PBI maps

Look at my response here (similar but in Spain)

http://community.powerbi.com/t5/Desktop/Filled-map-error-on-Province-Zaragoza-amp-gt-puts-in-Mexico/...

[franorio]

Thanks Sean, 

About using the provinces, i need to create a new column with them, the ones i have in my report are letters..

A = Salta,

B = Buenos Aires

C = Ciudad Autonoma

...

Q = Neuquen...

would you please help me, with the formula to create the new calculated column to transform each letter in a State/Province?

Thanks!

[Sean · Accepted solution]

@franorio

You can create a new DAX Column using SWITCH like this... Just add all other letters and their corresponding values

Column =
SWITCH (
    'Table Name'[Province],
    "A", "Salta",
    "B", "Buenos Aires",
    "C", "Ciudad Autonoma",
    "Q", "Neuquen"
)

Or in the Query Editor - Add column tab - Conditional Column

Hope this helps!