Skip to main content
Microsoft Idea

Power BI

Needs Votes

Please support 2 digit ISO country codes also.

Vote (124) Share
's profile image

on 07 Jan 2016 03:06:23

I noticed that the completed installed base of our machines was not shown on the Bing Map. After experimenting I realised that it was because our ERP system works with 2 digit ISO country codes, while it seems you need the 3 digit country code. Our ERP system is limited to 2 characters. It would be great if Power BI supports 2 and 3 digits, For example, the country code RU did not show our machines in Russia.

Comments (11)
's profile image Profile Picture

Jens Klöker on 25 Mar 2021 07:35:55

RE: Please support 2 digit ISO country codes also.

I tried it out today by using the filled map and a 2 digit iso code field containing "RU" and data-categorized as "Country" for the location well. This worked like expected. However I don't know if it works in general. An official MS statement would be great, since they still train people to use 3 digit codes instead of 2 digit codes in an official learning path (https://docs.microsoft.com/en-us/learn/modules/visuals-in-power-bi/5-map-visualizations).

's profile image Profile Picture

Jens Klöker on 24 Mar 2021 17:22:42

RE: Please support 2 digit ISO country codes also.

OMG - I hope this is supported in the meanwhile. I don‘t want to know, how many wrong insights have been created by Power BI users worldwide due to this behavior.

's profile image Profile Picture

Tolga on 05 Jul 2020 23:41:19

RE: Please support 2 digit ISO country codes also.

I think we need full location code support from UN.

https://www.unece.org/cefact/locode/welcome.html

's profile image Profile Picture

Ana Valentí on 05 Jul 2020 23:25:04

RE: Please support 2 digit ISO country codes also.

Very much needed! It will simplify and avoid many intermediate process

's profile image Profile Picture

Power BI Ideas Admin on 05 Jul 2020 23:25:02

RE: Please support 2 digit ISO country codes also.

Absolutely needed! This would make our life a lot easier!

's profile image Profile Picture

Victoria Ventosa on 05 Jul 2020 23:24:58

RE: Please support 2 digit ISO country codes also.

Hi, this is very much needed. We are taking data straight from Microsoft Dynamics (aprox. 20k records) and the addresses have the 2-digit code for country, never even heard about a 3-digit before... And because of this Bing Maps is placing addresses all over the place: Turkey in North Corea, Spain in Argentina, UK in Australia, it is a mess!

's profile image Profile Picture

Zoe on 05 Jul 2020 22:47:59

RE: Please support 2 digit ISO country codes also.

I also spent/wasted quite a bit of time trying to figure out why Russia was not showing up on my map. I find it crazy that ISO 3166 Alpha-2 codes are not used.

's profile image Profile Picture

Christopher on 05 Jul 2020 22:40:24

RE: Please support 2 digit ISO country codes also.

Definitely.

's profile image Profile Picture

Michael on 05 Jul 2020 22:37:42

RE: Please support 2 digit ISO country codes also.

Currently, Russia (RU) is not shown properly as 2-digit ISO code while other countries are. Would be great to have full support as the current state is pretty misleading.

's profile image Profile Picture

Koen Verbeeck on 05 Jul 2020 22:21:36

RE: Please support 2 digit ISO country codes also.

This would be nice indeed. For Virgin Islands, VG is recognized, but VI isn't.