Display Points within a Distance Radius on a Power BI Map 03-20-2019 20:33 PM

[deldersveld]

Detail on setup is on the DataVeld blog: https://dataveld.com/2019/03/20/display-points-within-a-distance-radius-on-a-power-bi-map/

Download the PBIX here on the Data Stories Gallery.

eyJrIjoiYzc0MTk4MTctZGRhYS00YmQyLWE5ZWItZGQ5N2YwZTgzZGM4IiwidCI6ImFjYzhhYWE1LWYxOTEtNDgyZi05MjFiLWNmNmMzM2E1ODgzMiIsImMiOjF9

[emily_budinger]

Super helpful! Do you know what the distance measure would look like for miles instead of km? 

[Anonymous]

@deldersveld You did great work! This is very helpful for me what I want to do could be solved with your example! Thanks a lot!!

[JoyceMachokoto]

Does anyone know how I can get this to be by county/zipcode rather than city?

Thanks in advance 

[some1else]

There's probably a much efficient solution but if you can get the polygons for each ZIP/County you can then load the shape in QGIS and calculate their centroids (basically the middle of the polygon). That would result in a specific coordinate for each ZIP code you could use.

[AlexandreCruz]

Hi thanks for the interresting post, but i can´t seen to understand how the maximum distance (km) filter works because there is no relation between any tables.

Thanks for your time

[derektd]

I love this but I need a slight variation. I am trying to plot locations in reference to a different set of data points. This meets 90% of my requirements the only difference is I need to select from one set of locations to specify the reference point and the and plot locations from a different set for a certain area around that reference location. Any ideas how to accomplish that, or have you seen this done before.

It seems your solution is very close it looks like I just need a secondary table with locations and then to figure out how to connect the two so when you select the reference point it plots out the surrounding locations from the second larger table.

[some1else]

Maybe capturing the current selected value coordinates and suppling them to the analysis? Another cool thing would be calculating in meters, instead of kilometers.

[jcarville]

I haven't seen this done before with PBI, looking forward to reading the blog about it.