Forum Discussion
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
Anonymous , 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
2 Replies
Anonymous , 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!
