Forum Discussion

cwayne758's avatar
cwayne758
Helper IV
10 years ago
Solved

Incorrect map location

Hello,   The Map visual seems to be plotting some of my locations incorrectly (see attached).     Example of data; Florida, United States, 32217  
Need Help
  • asocorro's avatar
    asocorro
    10 years ago

    cwayne758 It seems the state is confusing the mapping.  Look at how I got it to work:

     

Anonymous's avatar
Anonymous
Not applicable
9 years ago

This usually works for me:

 

Create a new calculated column that concatenates the street address, city, state/province, postal code, and country. It seems to geocode faster this way as well:

 

ShipToLocation = 'Details'[Ship To Address] & " " & 'Details'[Ship To City] & " " & 'Details'[Ship To Region] & " " & 'Details '[Ship To Postal Code] & " " & 'Details'[Ship To Country]

 

Instead of placing multiple location-related fields in the location well for the Map visual, just put this one new field in there. This full location can be used with the ArcGis map visual.

  • CharlesK's avatar
    CharlesK
    Frequent Visitor
    8 years ago

    Jesus!! this worked like gold!!

    i'm in Kenya so Maps couldnt find aaaany of my towns....

    so i read this and did it kinda half assed...

    i put "Kenya-" infront of every town name.

    it found each and every single town!!!!!

    Kudos sir.

  • smgt90's avatar
    smgt90
    Frequent Visitor
    6 years ago

    Thanks, this tip helped me but I put the country then the state and then the city all separated by a space. I tried sorting it as city "space" state and it didn't work.