Distance Driven Analysis in PowerBI

Few months ago, I was busy searching for a solution to filter data points on a map based on a variable-distance. This was in response to a need for a dynamic dashboard in my production environment to filter (encircle) locations/sites within a given radius and generate insights according to that radius. I knew Tableau Software would provide a simple and low-code solution using BUFFER calculations. However, PowerBi was the sole choice in the production environment. My search for PowerBI based solution led me to a solution by David Eldersveld. I had to shelf the solution at that time because of complexity of the DAX code involved.


Forward to last week (Week 43/2021). My interest on distance driven analysis was re-ignited when I came across the PowerBI's Workout Wednesday by Meegan Longoria. I felt this was the opportune time to implement David Eldersveld steps into this challenge. I followed most of the steps and the code, albeit, unsuccessful with the challenge. As someone who was keen and needed the solution for distance-driven analysis, I did not hesitate to follow through Meagan Longoria's solution when it was published and this time the solution worked to produce the below interactive report.



In designing the above report, I attempted to use the Mapbox Visual instead of the default PowerBI map. However, filtering process could not work as expected, as shown in the below interactive report. I prefer the Mapbox visual because it provides me with power to customize map layers, fonts, colors to my desire.



38 views0 comments

Recent Posts

See All

Creating DAX Tables in PowerBI

Thanks to Spencer Baucke for exciting lessons on creating tables using DAX. The Year 2021, week 20 version of Workout Wednesday provided good practice on creating tables using SUMMARIZE formula. Thi