Complex Map Visuals

[Anonymous]

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 ID	Locations
1	USA
2	USA, Canada
3	USA, India
4	India
5	Canada

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.

[Greg_Deckler · Accepted solution]

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