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?
This 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!
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:
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.
Can you provide your data or a sample of it that isn't working as expected?
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.
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 tried to concatenate "land" and "postal code" but it doesn't work for Austria and Switzerland. May the land code "AT" and "CH" doesn't work.
I have concatenate "postal code" and "place". Now it seems to me that this is still working.
Hi, I am having the very same problem.
I have PLZ from Austria and Power BI notifies me that I need to add more information. I have also tried to concatenate "Austria" "AT" before and after the postal code.
Nothing worked for me, what do you mean by using the place? I dont have that information in my data set.
How should the field look like so it can be represented in the map?
Same here but for a change with Australian post codes. Most showing correctly but some are shown in Europe although it's definitely an Australian post code. We also have the correct country field but PBI seems to ignore that even if its placed into the location field of the visual as an additional element to post code. There seems to be a bug somewhere.
Just a quick update: adding the country name in front of the post code with a custom column fixed the problem for us: [Country + Post code]="Australia "&[PostalCode] that of course assumes that all customers are in Australia which is the case in that instance. Interestingly following on with the post above: the same approach with "AU" did not work.
Sessions include practical, hands-on experience that will help you take the next step in your career and know-how.
Difinity is the largest Microsoft Data, AI, Power BI, Power Platform and Business Applications Conference in New Zealand.
This conference returns live and in-person in Copenhagen this 28 November-01 December with 4 Microsoft Keynotes, 9 Tutorials, and 120 Sessions.
Join us in Las Vegas to experience community, incredible learning opportunities, and connections that will help grow skills, know-how, and more.