Map Visual with Radius drawing

[ldtechgeek]

Hello, 

I am hoping to get some direction on the below requirement on how to achieve it. 

My data includes a List of Warehouses and list of Customers with Ship to Addresses. 

Each Warehouse ships material to different Customer ShipToAddresses. 

I need to create a Map Visual where I need to identify warehouse location and create a 50 mile and 100 mile radius around it. I also need to identify all the Customer ShipToAddresses within those radius. 

A filter would be a warehouse, where a user can filter on a warehouse and it would show all the customer ship to addresses and two radius circles around the warehouse. 

Can anyone help with this?

Is this possible?

[v-karpurapud]

Hi @ldtechgeek 


I wanted to check if you’ve had a chance to review the information provided. If you have any further questions, please let us know. Has your issue been resolved? If not, please share more details so we can assist you further.

Thank You.

[v-karpurapud]

Hi @ldtechgeek 

We haven't received a response to our last message and wanted to follow up to see if you have found a solution. If you still need help, please share more details so we can assist you further.

Thank you.

[v-karpurapud]

Hi @ldtechgeek 

Thank you for submitting your question to the Microsoft Fabric Community Forum, and thanks to @lbendlin , @Royel and @danextian  for offering helpful suggestions.

could you please confirm if this has resolved your issue by suggested solutions? If you are still encountering any difficulties, please inform us and we will be glad to assist further.

Regards,
Karpurapu D,
Microsoft Fabric Community Support Team.

[danextian · Accepted solution]

Hi @ldtechgeek 

You can use the Haversine formula to calculated the distance between two coordinates. Keep in mind that latitude and longitude data are necessary.  Please see the attached sample pbix.

[Royel]

Hi @ldtechgeek thank you for asking question. 

So you want to map warehouses with 50-mile and 100-mile radius to see which customers are nearby. The best option is to choose ArcGIS Maps visual because it is default visual and support up to100-mile radius perfectly. 

You can another similar solution here Community LInk

Is it helped? ✔ Give a Kudo • Mark as Solution – help others too!

[lbendlin]

Keep in mind that these values are immutable.  There is no need to use measures for this - either use calculated columns with great circle distances (haversine for short distances) or - better - compute this further upstream for all permutations of warehouses and customers.