topic Re: Display Points within a Distance Radius on a Power BI Map in Data Stories Gallery

Display Points within a Distance Radius on a Power BI Map

deldersveld — Thu, 21 Mar 2019 03:33:48 GMT

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

Re: Display Points within a Distance Radius on a Power BI Map

jcarville — Thu, 21 Mar 2019 09:49:43 GMT

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

Re: Display Points within a Distance Radius on a Power BI Map

derektd — Mon, 10 Feb 2020 20:18:37 GMT

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.

Re: Display Points within a Distance Radius on a Power BI Map

AlexandreCruz — Tue, 28 Jul 2020 08:57:44 GMT

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

Re: Display Points within a Distance Radius on a Power BI Map

some1else — Thu, 13 May 2021 15:07:47 GMT

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

Re: Display Points within a Distance Radius on a Power BI Map

Anonymous — Fri, 23 Jul 2021 03:57:10 GMT

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

Thanks in advance

Re: Display Points within a Distance Radius on a Power BI Map

some1else — Fri, 15 Oct 2021 14:18:34 GMT

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.

Re: Display Points within a Distance Radius on a Power BI Map

Anonymous — Sat, 22 Jan 2022 22:22:28 GMT

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!!

Re: Display Points within a Distance Radius on a Power BI Map

emily_budinger — Mon, 20 Mar 2023 17:05:33 GMT

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

Re: Display Points within a Distance Radius on a Power BI Map

Excelst — Thu, 13 Feb 2025 16:52:36 GMT

You could just multiply the final distance(km) result by 0.621371 and that should give you the result in miles.