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:

     

_seanrich_'s avatar
_seanrich_
Frequent Visitor
6 years ago

The address data that I'm using comes from sources that I have no control over, so it appears that these addresses are pulled from Google Maps, or unreliable sources. What I ended up doing was finding the address exactly as it is in Bing, and creating a manual table to relate my dataset addresses to the Bing addresses, and replacing them via a calculated column. Example below.

 

  • I have a table in my dataset with the address field; we'll call it Dataset[Address].
  • Manually created table is named MappedAddresses with columns MappedAddresses[DatasetAddress] and MappedAddresses[MapAddress] (with MapAddress being the Bing address).

 

Two new columns are created in Dataset as follows:

 

MappedAddress = RELATED(MappedAddresses[MapAddress])

ReplacedAddress = IF( ISBLANK('Dataset[MappedAddress]), Dataset[Address], Dataset[MappedAddress] )

 

This is pulling the new Bing address (MappedAddress) where needed, but keeping the dataset address where plotted correctly. I'm using the Dataset[ReplacedAddress] column to plot these datapoints on the Map visualization.