Forum Discussion
Multiple locations on one map
Hi Everyone,
I cannot figure out how to add multiple latitude and longitude sets to the same map in Power BI.
For example:
| Company | Latitude 1 | Longitude 1 | Latitude 2 | Longitude 2 |
| Walmart | 36.894026 | -94.845577 | 38.989526 | -94.403831 |
How do I add both the latitude and longitude sets to the same map?
Any help will be appreciated.
Best regards,
Coenraad
4 Replies
CoenraadJ - Unpivot your lat/long columns. Or basically, you need 2 rows for Walmart
Thank you. I was hoping there would be an alternative solution.
CoenraadJ - Sorry, I'm not aware of one if it exists. 😞
CoenraadJ , As far I know you can add only one set in one map. Try if unpivot can help
https://radacad.com/pivot-and-unpivot-with-power-bi
Transpose : https://yodalearning.com/tutorials/power-query-helps-transposing-data/
