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.
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.
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.
I see. You can always send me the locations at [email protected].
I wish you luck with figuring out how the map feauteres work in Power BI. They are not straight forward.
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
