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.
Comments