Forum Discussion
Display various data (different categories) on a single map + use of slicer
To show the closet workers, we need to know the distance between each worker and location. To calculate the distance between two points here, we need to know the latitude and longitude of each worker and location. You can refer to this thread for the calculation method. But I don’t think we can achieve the final goal only on a single map. Once we select a location in the slicer, the workers in the map will be filtered out. So we may need two maps, one map will show the selected location and one will show the nearest workers.
There is another thread which use power query to do the similar thing.
Best Regards,
Herbert
Microsoft Employee
To show the closet workers, we need to know the distance between each worker and location. To calculate the distance between two points here, we need to know the latitude and longitude of each worker and location. You can refer to this thread for the calculation method. But I don’t think we can achieve the final goal only on a single map. Once we select a location in the slicer, the workers in the map will be filtered out. So we may need two maps, one map will show the selected location and one will show the nearest workers.
There is another thread which use power query to do the similar thing.
Best Regards,
Herbert
Thank you Herbert for your message.
That's indeed the only solution I'm afraid.
The related post are however very relevant and should help me build a more robust solution.