top of page

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.

Recent Posts

See All

Utilizing the new page navigator feature in #PowerBI.

This week's Wednesday work-out challenge aimed to challenge Power BI designers to utilize the recently released Page Navigation features. The new features were released in the November 2021 Power BI

Creating Spark lines in Power BI

Happy new year and wish a productive, prosperous and healthy 2022 to all!! Microsoft continues to prove why Gartner has been recognizing Microsoft as a Magic Quadrant Leader in analytics and business

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


Post: Blog2_Post
bottom of page