Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Complex Map Visuals

Hello everyone,

 

I need some help to create an advanced map visual.

Say i have two columns Project ID and Locations

Now i have multiple locations for some projects 

Project IDLocations
1USA
2USA, Canada
3USA, India
4India
5Canada

 

Now on the map visual I want the projects to be circled at all the locations, ie, USA and India should have a mark for project 3; USA and Canada should have a mark for project 2, and so on.

 

Please let me know how to do this.

Need Help
Show and Tell
Tips and Tricks
  • Greg_Deckler's avatar
    Greg_Deckler
    6 years ago

    Anonymous - Seems to me that you would want to split your Locations column by delimiter in Power Query Editor and then unpivot your Location columns.

1 Reply

  • Greg_Deckler's avatar
    Greg_Deckler
    Icon for Community Champion rankCommunity Champion
    6 years ago

    Anonymous - Seems to me that you would want to split your Locations column by delimiter in Power Query Editor and then unpivot your Location columns.