Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
helenah
Helper I
Helper I

Postal code areas on map

Hi,

 

I have postal code area information on several countries and I cannot seem to find a common way to map it in Maps. For example, Germany postal codes with two digits (https://en.wikipedia.org/wiki/List_of_postal_codes_in_Germany) or UK post codes with two letters (https://en.wikipedia.org/wiki/List_of_postcode_areas_in_the_United_Kingdom). For France, I was able to do this with format "FR, 66" and setting it as a County, However, same logic does not work for e.g. UK or Germany.

 

Is there any common way of showing the postcode area data on Bing map?

Is there any documentation on what levels of data Bing maps have per country (since it seems to differ)?

I have tried every possible format of 2-digit/letter zip code, country code and country name, in different orders, separated with comma or space, ... and selecting county, postal code, region, ... as data type.

 

Any help on the topic appreciated, even on single country level.

 

br,

Helena

4 REPLIES 4
NeossITAdmin
Regular Visitor

I found the best way to use this map was to use the lon and lan, it struggles every other way i've tried to use

 

Great Free Datasource below for Postcode data across globe.

https://www.aggdata.com/free/germany-postal-codes

 

helenah
Helper I
Helper I

Update: For UK, it seems to work if I have same format as France (e.g. GB, AB) and set it as "Postal code".

However, a common way would be great since I don't know how to show global / Europe level data on one map if one country requires the data to be shown as "Postal code" and the other as "County"...

@helenah

 

I don't exactly know what cause the difference in your case, just share something I've found.

The abbreviation such as FR-U, DE-BE can be recognized in Map and Filled Map if they're categorized as "state or province".


So for the problem in your case, the cause can be that your data violates some kind of geographic standard?

Another update - the above works for Map but not for Filled Map. Why is this?

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.