Azure Map showing postal code on incorrect country

Question

Azure Map showing postal code on incorrect country

David Fombella Pombal 5

Hi all I am using Azure Maps component on Power BI , in Spain Postal Code of Barcelona is 08000 but it is displaying it on north of Malasia.

It is using a Hierarchy drill down from country.... ES international code of spain.

regards

AshokPeddakotla-MSFT 18,646 Reputation points

2023-09-08T07:03:05.43+00:00

David Fombella Pombal Greetings!

I am using Azure Maps component on Power BI , in Spain Postal Code of Barcelona is 08000 but it is displaying it on north of Malasia.

Can you share the screenshot as well? Is it same with Address as well?
evenmyrvold 0 Reputation points

2023-09-27T05:54:33.6533333+00:00

Two examples from my side:

Norwegian postal code 9171 is placed to Tunisia:

(Land = Country code, Fylke = Region, PostnrLevering = Postal code)

Swedish postal code 43232 placed in Ohio, USA...

It seems the country code is not considered when placing the location on the map. In fact it seems specifically SE (Sweden) is not recognized at all (all seem to be put in the USA)...
LeelaRajeshSayana-MSFT 8,286 Reputation points

2023-09-27T19:33:11.0666667+00:00

Hi @evenmyrvold thank you for sharing additional information on this. We will investigate this issue further and share our findings with you.
rbrundritt 10,986 Reputation points Microsoft Employee

2023-09-27T20:37:40.66+00:00

Part of the issue might be that the data column names don't provide much insights on what it contains "OrgID_Land" doesn't convey any insights that it contains country code.
David Fombella Pombal 5 Reputation points

2023-09-28T12:47:35.7533333+00:00

@rbrundritt I don't understand your reply about "OrgID_Land" if it is a correct Country Code ISO code it should work? or am I wrong, please check my example with ES country code and categorized as Country or region, but when I add below a postal code goes to Malaysia instead of spain
rbrundritt 10,986 Reputation points Microsoft Employee

2023-09-28T14:55:52.96+00:00

There is no indicator for Power BI that "OrgID_Land" is a country code ISO. "SE" could mean "south east" for all it knows. If you haven't already, try to set the category for your data columns: https://learn.microsoft.com/en-us/power-bi/visuals/power-bi-map-tips-and-tricks#in-the-dataset-tips-to-improve-the-underlying-dataset

AshokPeddakotla-MSFT 18,646 Reputation points

2023-09-08T07:03:05.43+00:00

David Fombella Pombal Greetings!

I am using Azure Maps component on Power BI , in Spain Postal Code of Barcelona is 08000 but it is displaying it on north of Malasia.

Can you share the screenshot as well? Is it same with Address as well?
evenmyrvold 0 Reputation points

2023-09-27T05:54:33.6533333+00:00

Two examples from my side:

Norwegian postal code 9171 is placed to Tunisia:

(Land = Country code, Fylke = Region, PostnrLevering = Postal code)

Swedish postal code 43232 placed in Ohio, USA...

It seems the country code is not considered when placing the location on the map. In fact it seems specifically SE (Sweden) is not recognized at all (all seem to be put in the USA)...
LeelaRajeshSayana-MSFT 8,286 Reputation points

2023-09-27T19:33:11.0666667+00:00

Hi @evenmyrvold thank you for sharing additional information on this. We will investigate this issue further and share our findings with you.
rbrundritt 10,986 Reputation points Microsoft Employee

2023-09-27T20:37:40.66+00:00

Part of the issue might be that the data column names don't provide much insights on what it contains "OrgID_Land" doesn't convey any insights that it contains country code.
David Fombella Pombal 5 Reputation points

2023-09-28T12:47:35.7533333+00:00

@rbrundritt I don't understand your reply about "OrgID_Land" if it is a correct Country Code ISO code it should work? or am I wrong, please check my example with ES country code and categorized as Country or region, but when I add below a postal code goes to Malaysia instead of spain
rbrundritt 10,986 Reputation points Microsoft Employee

2023-09-28T14:55:52.96+00:00

There is no indicator for Power BI that "OrgID_Land" is a country code ISO. "SE" could mean "south east" for all it knows. If you haven't already, try to set the category for your data columns: https://learn.microsoft.com/en-us/power-bi/visuals/power-bi-map-tips-and-tricks#in-the-dataset-tips-to-improve-the-underlying-dataset

Answer 1

David Fombella Pombal 5

Hi all,

Using a column country code with value ES with Country or Region as Category

And a postal code ( codigo postal in spanish column name) with category Postal Code.

ES Country Code
08000 Postal Code

Points a location in Malaysia please see image

badmap

Azure Map showing postal code on incorrect country

1 answer

Activity