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

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. 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
Employee
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
Employee
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
Fabric Community Conference

Microsoft Fabric Community Conference

Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.

February 2024 Update Carousel

Power BI Monthly Update - February 2024

Check out the February 2024 Power BI update to learn about new features.

Fabric Career Hub

Microsoft Fabric Career Hub

Explore career paths and learn resources in Fabric.

Fabric Partner Community

Microsoft Fabric Partner Community

Engage with the Fabric engineering team, hear of product updates, business opportunities, and resources in the Fabric Partner Community.