Forum Discussion

JayP's avatar
JayP
Regular Visitor
8 years ago
Solved

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...
  • GilbertQ's avatar
    GilbertQ
    8 years ago

    Hi JayP

     

    Do you have an example of the addresses that are not mapping correctly?

     

    Also when you click on the column can you ensure that the Data Category is set to Address?

     

    And if that does not work, then try City also

GilbertQ's avatar
GilbertQ
Icon for Super User rankSuper User
8 years ago

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

  • JayP's avatar
    JayP
    Regular Visitor
    8 years ago

    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.

    • GilbertQ's avatar
      GilbertQ
      Icon for Super User rankSuper User
      8 years ago

      Hi JayP

       

      Do you have an example of the addresses that are not mapping correctly?

       

      Also when you click on the column can you ensure that the Data Category is set to Address?

       

      And if that does not work, then try City also

    • v-ljerr-msft's avatar
      v-ljerr-msft
      Icon for Microsoft Employee rankMicrosoft Employee
      8 years ago

      Hi JayP,

       

      Have you tried the solution provided by GilbertQ above? Does it work in your scenario? If it works, could you accept it as solution to close this thread?

       

      If you still have any question on this issue, feel free to post here. :smileyhappy:

       

      Regards

      • JayP's avatar
        JayP
        Regular Visitor
        8 years ago

        Apologies for the late response I got pulled back to other stuff and had to put my Power BI play/learning on hold.
        I'm not able to find this data category setting in either the query editor window or the visualisations window (which at present only shows a map and a pie chart).
        The column value for address: = Table.SelectRows(#"Changed Type4", each ([Full Address] = "78 Virginia Rd, Wanganui, New Zealand"))

         

        It is plotted at a Virginia Rd in Conneticut US.
        The formatting of the address above is the same as it is for the many others that work and correctly point to locations in the correct city/country