Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Don't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.

Reply
bloffet
Frequent Visitor

Display various data (different categories) on a single map + use of slicer

Dear all,

 

I'm building a report for the company X, which present on a map the company X workers(based on their home address) and locations of that company X (also based on their address).

 

The aim is to allow Company X management to quickly identify which worker could replace another one (if he's sick for example) on a given location, based on the proximity of the worker and that location.

 

For this I use three tables : Locations / Workers / Postcodes-cities. They are linked together by the postcode.

 

The way I I've built my report is to append my locations and workers tables, and display them on a map.

I use the legend (location or worker) to display the points in a different color (blue and yellow respectively). I then use my postcode-cities as a slicer . This works well, and you can see a sample below.

 

loc.png

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

The question I have is the following though : I'd like not to use a postcode as a slicer, but rather the location.

The idea would be to see on the map which workers lives the closest from that location. On my map, I should then only see one blue point (=the selected location) and the closest workers (=yellow points).

 

I however does not know how to achieve this on a single map.

Would anyone of you have an idea ?

 

Thanks already for the help.

Benoît

1 ACCEPTED SOLUTION
v-haibl-msft
Microsoft Employee
Microsoft Employee

@bloffet

 

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.

 

Display various data (different categories) on a single map + use of slicer_1.jpg

 

Best Regards,

Herbert

View solution in original post

2 REPLIES 2
v-haibl-msft
Microsoft Employee
Microsoft Employee

@bloffet

 

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.

 

Display various data (different categories) on a single map + use of slicer_1.jpg

 

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.

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.

Feb2025 Sticker Challenge

Join our Community Sticker Challenge 2025

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!

Jan25PBI_Carousel

Power BI Monthly Update - January 2025

Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.

Jan NL Carousel

Fabric Community Update - January 2025

Find out what's new and trending in the Fabric community.