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
Power_BI_Adapt
Resolver I
Resolver I

How to use Dutch postal codes in map visualisation

Dear All,

 

I try to show Dutch customers in the map in Power BI, based ont he postal code. Currently it has been mixed up with locations in Belgium. How can I make sure / identfy just only the locations in the Netherlands? 

 

For instance: does a source exist to map easily Dutch postal codes with longitude and latitude data? Or better to use a country code?

 

Any suggestion is welcome!

 

Thanks

1 ACCEPTED SOLUTION
amitchandak
Super User
Super User

@Power_BI_Adapt , Create new columns ane try to use them as post code

[Country Code] & " , " & [Post Code]

 

or

 

[Post Code] & " ," & [Country]

 

or refer

https://community.powerbi.com/t5/Desktop/How-can-I-locate-Places-on-map-using-PostalCode/m-p/123407

View solution in original post

2 REPLIES 2
amitchandak
Super User
Super User

@Power_BI_Adapt , Create new columns ane try to use them as post code

[Country Code] & " , " & [Post Code]

 

or

 

[Post Code] & " ," & [Country]

 

or refer

https://community.powerbi.com/t5/Desktop/How-can-I-locate-Places-on-map-using-PostalCode/m-p/123407

Second option worked for me. My work laptop showed different locations then my work pc when i used dutch postal codes. With the second solution ([Post Code] & " , " & [Country]) it showed the correct data in both cases. Thanks for the tip!

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.