Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Solved! Go to Solution.
@shivalika - Seems to me that you would want to split your Locations column by delimiter in Power Query Editor and then unpivot your Location columns.
@shivalika - Seems to me that you would want to split your Locations column by delimiter in Power Query Editor and then unpivot your Location columns.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.