Map visualation show wrong locations after update

Hi jdoyon,

I'd like to suggest you create custom hierarchy and use drill down to instead the concatenate columns. Actually, after the update of bing map control, the concatenate feature is not fully support on map.

Reference:

Power BI Desktop June Feature Summary

The Bing Maps team is forcing a two-fold change for Power BI; they are deprecated the Bing Maps v7 Control, and are also switching to a new geocoder. The target date is June 30th.
At this time, please download Jun release desktop and define GEO hierarchy. To take full advantage of this, you'll need to set the Data Category for each column correctly.

You can try to setting the concatenate column to 'place' catagory to work throuth it.

Notice: this solution not works on some of senarios.(some contcatenate locations still not suport)

Regards,

Xiaoxin Sheng

Hi,

Thanks Xiaoxin it's working now.

In case someone else run in the same situation, here are the details steps I did:

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 - I used the new custom column as location for the Map Control.

I also published it on Power BI Online and the maps renders properly the different locations now.

Jo