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 s...
Need Help
  • 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.

stty1244's avatar
stty1244
Frequent Visitor
9 years ago

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
Icon for Microsoft Employee rankMicrosoft Employee
9 years ago

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 Guce.

  • Anonymous's avatar
    Anonymous
    Not applicable
    9 years ago

    stty1244 Just writing a small note for when you are dealing with the map visualization (Filled Map):

     

    I've found that it performs much better if you try this combination: Postal code&" "&Country. This, of course, assumes that you can extract all the relevant postal codes from somewhere. Anyhow, I've succesfully pinpointed several locations in scandinavia, even though their city names might be the same as some cities in USA.

    • Anonymous's avatar
      Anonymous
      Not applicable
      9 years ago

      stty1244

       

      Did you ever get your problem solved?

      • stty1244's avatar
        stty1244
        Frequent Visitor
        9 years ago

        Hi Unfortunately not.

        I'm giving up on it for a while - its something that has occurred while I am learning about Powe BI mapping. I'm more than happy to provide the pbi file - however not sure how to load that up as that isn't an option on my message screen. Am happy to share via email/dropbox etc.

         

        If I get any further (i will try latitude/longitude at some point) I'll have another go and if I ever figure it out will post here. 

        BTW - tried using just isolated examples, changing data category, concatenating values (such as zip and country, zip, city, country etc) together. Hopefully will become clearer as I get better at this.