The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
Hi community
I have been confronted with a request to visualize something like this on a map:
In my case, i have three tables: Warehouses, Stores, Cities with 1000+ citizens
I want my users to define a range of 10-1000miles and get all stores and all cities around a selected warehouse on a map. Ideally, the map is painted like in the above example but I would be already happy with just dots been plotted.
All three tables have geo-coordinates, so the challenges is to find a way to calculate the distance between each warehouse and each store and visualize them on the map. As i would be simply too much calculation if that would run every time i click on a warehouse, i thought there must be a smarter way.
I'm also aware of the ACRIS map that comes with some kind of ISOCHRONE service but it seems to be very limited to their data sources.
Happy to see your ideas on the challenges.
Best regards
Thorben
Hi @Anonymous ,
Sorry for that, but I also not found an effective solution to achieve your requirement, we can use measure that calculated the distance between the selected warehouse and other stories in the visual filter may work dynamically but it actually will calculate for each point.
Best regards,
Community Support Team _ Dong Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.