Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Next up in the FabCon + SQLCon recap series: The roadmap for Microsoft SQL and Maximizing Developer experiences in Fabric. All sessions are available on-demand after the live show. Register now

MCz87

Bug with PowerBI Map visualisation - ZA and SA both shown on map as South Africa

Submitted by on ‎07-31-2023 07:20 AM

Hi, I have a data presented in Map visualisation (Map from standard PowerBI visualisations) and just dicovered that data for Saudi Arabia (ISO code SA) is shown on the map in place where South Africa is located (South Africa code is ZA -> the data for ZA are displayed correctly, so I have two bubbles in South Africa and no bubble over Saudi Arabia).

Could you please check and fix this? It worked correctly few months ago. The correct codes are SA for Saudi Arabia and ZA for South Africa.

 

SA ZA.JPG

Status: Investigating
See more ideas labeled with:
7 Comments (7 New)
Comments
Anonymous
Not applicable
‎08-02-2023 06:31 PM

Hi @MCz87 ,

 


Can you provide detailed version information so we can reproduce the issue? We'll get back to the product team as soon as it's acknowledged as an issue!
Thanks in advance!

 

Best regards.
Community Support Team_Caitlyn

MCz87
New Member
‎08-03-2023 07:29 AM

Yes, sure... I wanted to send some files as answer for the email but seems this not works... so I post it here.

 

I have some dummy sales for different countries including ZA (South Africa) and SA (Saudi Arabia) according the ISO 3166-1 alpha-2 codes.

MCz87_2-1691072147985.png

 

And I created the Map visualisation with Country (set as location), sales (set as bublle size) and region (put as legent - to have bubbles within one region in the same colour).

 

I put 400 for SA to have the buuble bigger (to see it on map), all other are 100$... Bubble for SA should be on the Middle East, close to UAE, Kuwait etc.. .and not on South of Africa as it's now.

MCz87_3-1691072319616.png

 

I noticed this about month ago... When I created this visualisation two years ago, it worked correctly, it was OK still about 3 or 4 months ago.... Bug is since few weeks, maybe few months.

 

So this looks like SA is wrongly mapped by MS (PowerBI) on their maps... or MS changed the codes and no more use ISO codes (which one is used for Saudi Arabia in this case?). I guess this is bug, not change of mapping... So please report this issue to MS team.

 

tsalaheen
New Member
‎08-21-2023 07:54 AM

Good Morning Support Team:

Is this issue has been resolved.

Regards

Tarique

MCz87
New Member
‎08-22-2023 03:53 AM

Seems that not yet... 😞

Antonio_Alvarez
Regular Visitor
‎10-25-2023 09:17 AM

Hello,

 

I am experiencing the exact same issue. I have several countries with data, two of which are ZA = South Africa and SA = Saudi Arabia. However, both values are represented on the map visual as the country of South Africa. 

Is there an update to the backend mapping of the Power BI visual, or is there a way to modify via Power BI desktop?

Thanks

MCz87
New Member
‎10-26-2023 03:34 AM

Another country wrongly displayed is CR (Costa Rica). It is shown on the map in Europe, in the place where are situated Czechia (Czech Republic = CZ).

Antonio_Alvarez
Regular Visitor
‎10-31-2023 07:33 AM

Hey there,

 

Following up on my previous post. No support yet from Mircrosoft, but we found a work-around to make the map visual work. We just spelled out the full country names in a lookup table and used the full country name as the "Location" for the visual. This works as long as all countries are spelled correctly.

 

Thanks and good visualizing!

 

Idea Statuses