Dear Power BI community,
I am working on a task where end users can key in 2 zip codes to get the distance in miles in Power BI. I have got myself a Google Maps API key, but below are the 2 problems that I ran into:
1) I am trying to create a report where the end users can key in two 5 digit zip codes themselves, and the only way that I can think is to create a new parameter. However, the parameter will not let me create numbers in the increment of 1 from 0 to 99999. Does any of you know any other way to create a textbox/interactive visualization so that the end users can key in numbers themselves?
2) I was looking at different blog posts/ Youtube videos to see how to utilize the Google Maps API key in Power BI to find the distance between 2 points, and from what I have learned from them is that I need to create a function (let's call it Google Maps API Function) that connects to Google Maps, and then on the actual dataset (which contains an origin and destination zip code), I will create a new column to invoke the custom function (Google Maps API Function) I created.
Is there a way to make it work that the users can key in 2 zip codes, and then after keying in the 2 zip codes, the Google Maps API Function will then be triggered to run and return me with the distance?
The reason I am asking this is because I have no idea/no control over which zip codes the users are going to key in beforehand.
Also, it seems like I am not able to create a new column to invoke the custom Google Maps API function on the parameter I created for users to key in zip codes. Does anyone know a way around this?
Thank you so much. Any advice/suggestion will be greatly appreciated.
