Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Map Visual plotting wrong location, weighting seems off

I have building data come in separate for each element for an address: Address 1, City, State, ZIP. All the data is for a single state. I combine all fields into one Location field, showing a proper ...
General Comment
v-piga-msft's avatar
v-piga-msft
Icon for Resident Rockstar rankResident Rockstar
7 years ago

Hi Anonymous,

 

Based on your description, it seems that you have problems for only one  whcih plotted in another state.

 

Firstly, please check if you have installed the latest version of Power BI Desktop 2.66.5376.2521.

 

If it is convenient, could you share your sample data which could reproduce your scenario so that I could have a test. 

 

In addition, I would appreciate it if you could highlight the one which is incorrect and share your desired output.

 

You could have a referece of the video below which may make sense of you,

 

Incorrect map locations in Power BI and how to solve it

 

Best Regards,

Cherry

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    Map these three addresses:

    1. 1022 West Main Street, Bowling Green, KY 42104
    2. 1155 West Main Street, Shelbyville, KY 40066
    3. 308 VoTech Road, Lexington, KY 40511

    This is the original data that I received. They should all be in Kentucky, but none of them plot in Kentucky in the standard Map visual. (I haven't tried any other visuals yet.)

    1. This one plots to Missouri. The error is in the street address; city, state, and zip are all correct. Change Street to Avenue, then it plots correctly.
    2. This one plots to Illinois. This time, the address, city, and state are correct, but the zip is wrong. Change 40066 to 40065 for a correct plot.
    3. This one, the address is no more (street was renamed), but the city, state, and zip are correct.

    From my observations, I assume Bing/PBI ignores or greatly de-emphasizes State, and puts much more importance on Address, City, and Zip. I think it goes, in order of importance, Address->City->Zip->State (ignored?). I would've assumed that if there are user entry errors, addresses and zips are the first to be wrong, whereas city and state are much more accurate. Bing's 'best guess' when there is a data error is off.

     

    My vote is for Bing/PBI to plot in order of importance: Country->State/Province->City->ZIP/Postal Code->Address. If at any point it can't find a match, it defaults to the last level of correct mapping. So for my three examples, they would all plot to the centerpoint of the state and city that were correct, with some indication that the rest of the address could not be found. I'd rather see a close proximity with an error warning instead of a seemingly out-of-place plot.

     

    Thanks for looking into this.