Forum Discussion

stty1244's avatar
stty1244
Frequent Visitor
9 years ago
Solved

map

Dear all,

I have created a map visualisation using US data, with US towns and states in Power BI desktop. I have set this up as a map. When looked at in PBI desktop, the USA map is displayed. (Not sure how to post image here sadly).

 

However, when I publish it online and look at it via app.powerbi.com, it shows the UK map. You can then scroll to the USA map to look at the data, but is there a setting i can change so it starts in the USA immediately?

 

I have tested changing the region on the PC (win 10), also using an amalgamated columne (City & ", " & Country), neither of which have resolved issue. Any pointers or tips?

 

Many thanks.

  • Anonymous's avatar
    Anonymous
    9 years ago

    stty1244

     

    Try this combination. I've gotten the desired results with this combination:

     

    Postal code&" "&State.

     

    Referring to the pbix, you sent me:

     

    stores[zip] & " " & stores[state].

     

    Let me know how it goes.

11 Replies

  • v-yulgu-msft's avatar
    v-yulgu-msft
    Microsoft Employee

    Hi stty1244,

     

    I was not able to reproduce your scenario. In my test, the map always starts in the USA map in Power BI service site as there only existing data records about USA city and states.

     

    Is there any UK location stored in source table? Can you share some sample data with me to test?

     

    Best regards,
    Yuliana Gu

    • stty1244's avatar
      stty1244
      Frequent Visitor

      Hi Yuliana,

      thanks for your reply...

       

      I'm based in the UK, which makes me wonder if there is some preset I need to change when looking at US (international) data.

      So in desktop, it correctly appears on US map, on Power BI service site, the map starts in the UK, although I can then scroll across to see the data, which is in USA. 

       

      There is one record (89, Madison St, Fremont) which for some reason it thinks is in Manchester, UK. However, when setting that up as USA, it still isn't happy.

       

      I can do - do you want it as pbx file (2mb?) or text? It is all test data.

       

      Best regards

      Tom

      • v-yulgu-msft's avatar
        v-yulgu-msft
        Microsoft Employee

        Hi stty1244,

         

        In my test, this specific location (89, Madison St, Fremont) is pointed correctly in both desktop and service.

        Desktop.

         

        Service.

         

         

        Which map visual did you use? If possible, you could upload your .pbix file for further analysis.

         

        Regards,
        Yuliana Gu
        ce.