Mapping nearest location with user input

[gaiurangb]

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.

Excel_File 

[Anonymous]

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.