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

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's avatar
Anonymous
Not applicable
9 years ago

stty1244

 

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

  • Anonymous's avatar
    Anonymous
    Not applicable
    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 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