✨ Master Maps with this Route Analysis in Power BI
Create a time based route animation using native maps and a dynamic axis.
Step 1: Build the Route Map
Use the Azure Map visual.
Assign latitude and longitude to location fields.
Add a sequence column to Point Order to draw route lines between points.
Step 2: Create a Time Table
Create a dedicated DAX table that represents the time axis used for animation.
This table is not related directly to the fact table.
Step 3: Add a Filtering Measure
Create a DAX measure that compares the route timestamp with the selected time value.
This measure controls which route segments are visible.
Step 4: Apply the Map Filter
Use the filtering measure on the Azure Map visual to show only valid points for the selected
time step.
Step 5: Add Play Axis (Dynamic Slicer)
Use the custom visual Play Axis as a dynamic slicer.
Connect it to the time table to animate the route progression.
#powerbi #routeanalysis #report #design #mapvisual