Forum Discussion
map
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.
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
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
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.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.