Forum Discussion

muchinski's avatar
muchinski
Icon for Resolver II rankResolver II
9 years ago
Solved

Map visual mark the wrong position for Cities outside USA

I am having this issue since the June release, it was working fine before.

The problem is with the Map visual. The ArcGIS map is working well.

 

In my example, the field City comes from a Multidimensional Model and it is classified as a City. I just realized that if I have a Tabular model and classify the field as 'Place', it works; but, come on, it is a city....it was working... (Also, there are no 'Place' classification on Multidimensional)

 

Many people are talking about this problem on the following thread, but this problem is different that the reported and delivered; so i opened this new thread.

https://community.powerbi.com/t5/Issues/URGENT-Map-Visualization-Not-Working/idi-p/190743

 

Following you can check how I am composing the name of City fields, and the difference between the two visuals.

  • muchinski

     

    The Bing Maps team is forcing a two-fold change for Power BI; they are deprecated the Bing Maps v8 Control, and are also switching to a new geocoder. Please refer to https://powerbi.microsoft.com/en-us/blog/power-bi-desktop-june-feature-summary/#maps.

     

    If you are using comma separated strings as a workaround to the earlier geocoder limitations, you should change to use a hierarchy. In this case, create a column called "Country", set data category to Country / Region, and add it above the State and City in the hierarchy. Then Drill Down via Hierarchy Drill (fork icon). Or you can use a City column directly as following screenshot. Please notice that there is no comma, Country for the values in City column.

     

    Users with comma separated concatenated values may see breaks, changing Data Category of this column to Place should work, and it is actually be design.

     

     

    Best Regards,
    Herbert

2 Replies

  • v-haibl-msft's avatar
    v-haibl-msft
    Icon for Microsoft Employee rankMicrosoft Employee

    muchinski

     

    The Bing Maps team is forcing a two-fold change for Power BI; they are deprecated the Bing Maps v8 Control, and are also switching to a new geocoder. Please refer to https://powerbi.microsoft.com/en-us/blog/power-bi-desktop-june-feature-summary/#maps.

     

    If you are using comma separated strings as a workaround to the earlier geocoder limitations, you should change to use a hierarchy. In this case, create a column called "Country", set data category to Country / Region, and add it above the State and City in the hierarchy. Then Drill Down via Hierarchy Drill (fork icon). Or you can use a City column directly as following screenshot. Please notice that there is no comma, Country for the values in City column.

     

    Users with comma separated concatenated values may see breaks, changing Data Category of this column to Place should work, and it is actually be design.

     

     

    Best Regards,
    Herbert

    • muchinski's avatar
      muchinski
      Icon for Resolver II rankResolver II

      Hello v-haibl-msft, thank you for this explanation. I just changed my dimensions ETL, created this hierarchy and everything is working very well!