Previously, we explored various methods for animating your dashboards using SQL. Whether you want to display real-time data or historical data animations, SQL method works great. However you’ll discover that SQL isn’t always necessary, especially when dealing with historical data. Instead, we introduce you to a handy custom visual known as “play axis,” available for download on the Microsoft app store.
You can find a link to the dataset we’re using in the video description below. We begin by importing this data into Power BI Desktop, where we’ll have all the necessary fields for visualization. The dataset revolves around a race between two cars and includes data on distance and speed, with speed presented in two variants: total speed, representing the vehicle’s actual speed, and speed reflecting changes between two points in time.
As we build our dashboard, we add titles and create measures, such as “minimum speed” and “maximum speed.” We incorporate gauge visuals to display speed, line charts for tracking both cars’ total speed over time, and clustered bar charts showcasing the distance traveled by each car. We make sure to provide a clean and informative visualization.
The highlight of this tutorial is the “play axis” visual, which allows us to animate the race over time. We adjust animation settings to enhance the viewing experience, emphasizing the moment when Car 2 overtakes Car 1 during the race.
In conclusion, this tutorial demonstrates creative ways to animate your dashboards and bring data to life, all while reminding us of the importance of determination and not giving up. We appreciate your viewership and encourage you to like and subscribe for more tutorials and updates in the future.
#DataVisualization #PowerBI #SQL #DashboardDesign #DataAnalytics #HistoricalData #MicrosoftAppStore #Visualizations #RaceAnalysis #AnimationTutorial