Forum Discussion
Location/Map defaults to USA?
I'm just starting out with Power BI so may have missed something....
I have a spreadsheet and one of the columns is an address column. Every (valid) cell contains an address in the format of street number, street, city, country.
All the address are in the same city in New Zealand and all formatted the same. No commas, no extra spaces, quote marks and all spelt correctly.
Out of the 80 rows nearly all are correctly "plotted" within NZ on the map except a handful... these are plotted in North America.
When I zoom into the US ones I see that the street names are the same as their NZ counterpart.
Given that the street, city and country are contained in the data, why is Bing opting for the US address? Does it look their first and if it finds one in the US then it uses that otherwise it looks deepeer?
I do not have the longitude or latitude for this dataset so am relying on the automated lookup.
These are urban streets that are being incorrectly plotted (rather than obscure country lanes) and just as prominent as those which have been correctly plotted.
6 Replies
- GilbertQ
Super User
Hi JayP
What data type did you set your column to in Power BI?
And what I typically do is always put in a comma between each item, with the country always being at the end. This has worked well for me in the past to ensure that it always gets the right location.
Here are some tips & tricks that could also assist: https://docs.microsoft.com/en-us/power-bi/power-bi-map-tips-and-tricks
Hi, I didn't put any datatype (nor know where to do so).
I clicked Get Data, pointed to the excel sheet, and accepted the defaults.
Then on the fields pane I clicked "Full address" and Power BI (desktop) automatically added a map visualisation for me. So I'm guessing it recognised the field as a location. In the visualisations field it shows "location" as "Full Address" - do I need to add another step to confirm it is meant to be location data?I think I had commas in before and the result was even more US-biased. So much so that only 2 of the 80 addresses were plotted in NZ.
