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.
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!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
105 | |
96 | |
79 | |
66 | |
62 |
User | Count |
---|---|
145 | |
113 | |
105 | |
85 | |
65 |