map

[stty1244]

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.

[v-yulgu-msft]

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]

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]

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]

@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]

@stty1244

Did you ever get your problem solved?

[stty1244]

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.

[Anonymous]

@stty1244

I see. You can always send me the locations at martin@valubi.dk.

I wish you luck with figuring out how the map feauteres work in Power BI. They are not straight forward.

[stty1244]

Many thanks Martin. I'll send you the pbix so you can have a look if you like.

If I make any progress, will post here.

Regards

Tom

[Anonymous]

@stty1244

Will look into this in a couple of hours. Just letting you know I'm still on it.

[Anonymous · Accepted solution]

@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]

HI Martin, thanks a lot for your help.

Following your advice I did the following - 

Set up new column in store table as

                Zip and Store = stores[zip] & " " & stores[state]

The data then looked as follows:

So this definitely fixed the desktop map appearing in USA, online map appearing in UK issue.

There is definitely something else odd going on with the data, but that is fine as this was a test example I got online anyway.

Many thanks for your help!

Regards

Tom