Forum Discussion
Resident RockstarMAP showing wrong locations
I am having some issues regarding plotting of locations in Power BI Maps using postal codes.
I have a column where I have concatenated Country name and postal code in format as "CountryName,PostalCode".
Earlier it worked very well but now it just cannot plot the location.
I tried plotting them using only postal codes , but still it couldn't plot the location , instead it plots location in
another country as postal codes are not unique worldwide.
Can anyone help me suggesting the format on how to pass postal codes with the country name to plot on Power BI Maps?
Thanks.
5 Replies
- Greg_Deckler
Community Champion
I've seen a couple posts about this. Power BI uses Bing Maps to geocode so I wonder if something changed on the Bing Maps side to cause some of these issues.
jwjwjwjwjwAdvocate II
Numerous countries and cities aren't showing up on maps, it has been happening off and on for quite some time. It would be nice to get an official acknowledgement from Microsoft so users with dashboards that rely on PowerBI maps can determine potential solutions.
- fhill
Not 100% what you are doing, but I just had to make these changes to get a County fill map to work. The Merged data column including the word 'County' in the merged data worked! Hope this helps a little...
FOrrest
v-huizhn-msftMicrosoft Employee
Hi rajulshah,
Which kind of map do you use? Could you share the data which is not shown correctly in your visualization for further analysis? There are some tips to help create map visual, please review: Tips and Tricks for Power BI Map visualizations.
Best Regards,
AngeliaI found the solution on https://community.powerbi.com/t5/Desktop/Map-visualation-show-wrong-locations-after-update/m-p/208462#M91916
1 - Upgrade to June 30th
2- In the datasource query editor, I created a custom column with this formula =Text.Combine({[Address],[City],[Country]}, ", ")
3 - In the Modeling Tab of PBI Desktop, I configured the data category for the new custom Column as type Place.
4 - Use the new custom column as location for the Map Control.
