Forum Discussion
Mapping nearest location with user input
Hello,
I have attached the Excel file, which has location id and Latitude, Longitude for the same.
I need to create a parameter where user can enter an address/area, city. Through Bing/Google MAP API I need to convert that address to Latitude - Longitude coordinates. Now I need to find locations within 500 Mtrs of that coordinates using Excel file.
I have used OwenAuger solution https://community.powerbi.com/t5/Desktop/Find-the-nearest-location-for-a-customer/td-p/217048 to fnd nearest sites.
My question is how do I implement address through parameter and using it in api URL?
Once I found the nearest site, how do I filter other reports when I have found nearest sites.
1 Reply
Hi gaiurangb ,
Please see this post regarding How to Get Your Question Answered Quickly:
https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490.
Best Regards,
Jay
Community Support Team _ Jay Wang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
