Forum Discussion
Advocate IIIProblem with map and postal code
Hey,
I try to use the map visualization but it seems that it doesn't work well. Some postal codes where shown in the wrong country.
So I try to use Land and Postal Code like
Location = Concatenate([land];concatenate(",";[postal code]))
If I use the coloum "Location" the map visual also doesn't schow all information right on the map.
If I use the coloum "Land" all countries shown correctly.
Has anybody an idea why it doesen't show all values correctly?
22 Replies
AFraHelper III
I had the same problem, and fixed it by concatenating Postal Code + City + Country.
Hope it will work for you!
- Greg_Deckler
Community Champion
Can you provide your data or a sample of it that isn't working as expected?
- Sebastian
For example the Code for the Coloumn Land is "CH" and Coloumn postal is "9016". (The format for the Coloumn "Land"is land and for Coloumn "Postal" is postal code).
If i use the Coloumn land in the visual all values where shown correctly.
If I use postal the visual shows the postal code "9016" in New Zealand but it is St. Gallen in Switzerland.
So my idea was to concatenate both.
My new Coloumn "Location" has the value "CH, 9016".
It seems that the visual ignore this value. All where shown correctly ecept values which are situated in Switzerland or Austria.
- Greg_Deckler
The problem is that New Zealand uses four digit postcodes that are apparently the same as Switzerland/Austria. The map is taking its best guess. Specifically, a 9016 postcode would be somewhere in Otago, Southland in New Zealand. What if you put both the "Land" column and the "Postal" column in the Location field and then some other field in the Values field?
I have a problem with a US postal code showing on the European side of the Map. I am only trying to get shipments out of our facilities by zip code but have state and country as part of the definition. Still, I have the following data:
Month Facility Weight CustName CITY State Zip February COLUMBUS 19540 A***** DORAL FL 33192 And it seems to think this is in Scandinavia somewhere. I will try adding street address and see if it makes any difference.
The problem may be that the zip code 33192 is not really in Doral but in Miami.
The lookup that Power BI is using would like it better if this said Miami. Sometimes, you may need to edit the zip code (after reading it in) to fit the visualization.
- Johnmatta
Advocate I
I'm having a problem with Globe map, it doesn't allow me to drop longitude and latitude in their field in the visual. Both long and lat have data type as longitude and latitude respectively and are formatted as decimal number and set to don't aggregate. Same happend with the filled map.
Any help pleas3? 
JuliänThis Topic is not solved! In Germany we have similar problems.
German postcode 99734 -> Nordhausen in Thüringen, is from Bing Maps located in Alaska, that's makes no sense. And we have much more examples.
I categorized the data. I created hierachies, with country. I concatenated it with Country infront of postcode, nothing works.
Please fix that Bugs!
