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
Solved! Go to Solution.
@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
@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!
User | Count |
---|---|
117 | |
62 | |
60 | |
47 | |
40 |
User | Count |
---|---|
111 | |
63 | |
62 | |
51 | |
48 |