How to Do Animation in Power BI

Static charts get the job done, but sometimes they fail to tell the whole story, especially when you're dealing with data that changes over time. Animating your Power BI reports lets you transform a simple dashboard into a dynamic narrative, showing trends and patterns evolving right before your eyes. This article will guide you through adding motion to your visualizations, explaining how to create animations that make your data insights clearer and more engaging.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

So, What Exactly Is Animation in Power BI?

When we talk about animation in Power BI, we're not talking about cartoon characters or complex motion graphics. Instead, it's about a specific technique for visualizing change over a period of time. Imagine watching a bar chart where the bars grow and shrink to show monthly sales throughout a year or a scatter plot where the bubbles move and resize to track product performance across quarters.

This is achieved by automatically filtering a report for successive values in a particular field, usually a date or time period. By rapidly cycling through these values — say, from January to December — the visuals on the report update in sequence, creating the illusion of movement. This allows you to see the journey of your data, not just the final snapshot.

Why Bother Animating Your Reports?

Adding animation might seem like a bit of visual flair, but it serves a practical purpose. It's a powerful tool for data storytelling that can make your reports more effective and impactful.

• Tell a More Compelling Story: Data evolves. A static chart shows results, but an animated chart tells the story of how you got there. Watching your website traffic grow month-over-month or seeing which regions spiked during a sales campaign helps stakeholders connect with the narrative behind the numbers.
• Highlight Key Trends and Outliers: Subtle changes can be lost in a static line chart. When animated, you can literally watch the trend unfold. Sudden spikes, dips, or anomalies become immediately obvious when they pop up in the sequence, drawing attention in a way a fixed image cannot.
• Make Complex Information Digestible: If you're comparing multiple categories over time, a static view can be a chaotic web of lines or a crowded cluster of dots. Animation isolates each time period, simplifying the view and allowing your audience to process the information one step at a time, making it much easier to understand.
• Increase Audience Engagement: Let's be honest — traditional reports can be dry. Motion naturally captures attention. An animated visual draws the viewer in and keeps them focused on the data, increasing the chances that your core message will be remembered.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

The Secret Weapon: The Play Axis Slicer

Power BI doesn't have a built-in "Animate This" button. To create these effects, you need to use a custom visual called the Play Axis (Dynamic Slicer). This handy tool is essentially a slicer with a play button. When you add it to your report, you can link it to a time-based field (like a date, year, or month). When you press play, it automatically cycles through each value in that field, one by one, filtering the entire report page accordingly and creating your animation.

How to Import the Play Axis Visual

Since it's a custom visual, you need to import it from Microsoft's AppSource marketplace first. It's free and only takes a moment.

1. In your Power BI Desktop report, look at the Visualizations pane on the right.
2. Click the three dots (...) at the bottom and select Get more visuals.
3. The AppSource marketplace will open up. In the search bar, type "Play Axis" and press Enter.
4. You'll see the Play Axis (Dynamic Slicer). Click on it, then click the blue Add button.
5. Once it's added, you'll see a new icon for the Play Axis in your Visualizations pane, ready to be used.

Step-by-Step Guide: Creating Your First Animated Chart

Let's walk through an example. Imagine we have simple sales data with columns for Order Date, Product Category, Sales Amount, and Country. Our goal is to create a bar chart showing sales by country and animate it to see how those sales changed annually.

Step 1: Prepare Your Data and Base Visual

First, make sure your data is properly formatted in Power BI, especially your date column. For animations, it's often better to have separate columns for the time periods you want to animate, like 'Year', 'Quarter', or 'Month Name'. You can easily create these in Power Query or using DAX formulas.

For this example, let's assume we have a 'Year' column. Now, let's build our basic visual.

• Create a new report page in Power BI.
• Add a Stacked column chart to the canvas.
• Drag Country to the X-axis field well.
• Drag Sales Amount to the Y-axis field well.

You should now see a static bar chart showing total sales for each country across all years.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

Step 2: Add and Configure the Play Axis

Now it's time to bring in the magic.

1. Find the Play Axis icon in your Visualizations pane and click it to add it to your report canvas. It will look like a simple "play" button.
2. Select the new Play Axis visual. In the Visualizations pane, you'll see its own field well.
3. Drag your time-based field — in our case, the Year column from your data table — into this field well.

The Play Axis slicer will now display the first year available in your data. At this point, it's already connected to your bar chart. The bar chart is only showing data for that single, initial year.

Step 3: Press Play!

This is the fun part. Click the play button on the Play Axis visual. You'll see the bar chart come to life. The heights of the bars will change as the slicer cycles through each year in your dataset, dynamically filtering the sales data. Congratulations, you've just created an animated report!

Customizing Your Power BI Animation

The default settings are great, but the Play Axis visual offers plenty of customization options to fine-tune your animation. To access these, select the Play Axis visual and go to the Format visual tab (the paintbrush icon) in the Visualizations pane.

Animation Settings

This is where you'll find the most important controls:

• Start: You can set this to "On" if you want the animation to start automatically when a user opens the report page. Otherwise, they'll need to press play manually.
• Loop: By default, the animation stops at the last value. Turn "Loop" on to make it repeat continuously, which is useful for kiosk displays or presentations.
• Auto Adjust Time: If toggled on, it will allocate an equal amount of milliseconds among all items.
• Milliseconds: Allows control for how many milliseconds each step will wait before calling the new value.

Colors

Under this section, you can change the default colors of the play, pause, and stop buttons, as well as the slider itself, to better match your report's branding and design theme.

Advanced Tips for Better Animations

Once you've mastered the basics, here are a few extra tips to take your animated reports to the next level.

Animating a Scatter Plot ("The Hans Rosling Effect")

Perhaps the most famous use of animated data is the "Hans Rosling effect," where a scatter plot animates over time to show how metrics for different categories (like countries) change. Recreating this is surprisingly easy in Power BI.

1. Add a Scatter chart to your report.
2. Drag a metric like Life Expectancy to the X-axis and another like GDP per Capita to the Y-axis.
3. Drag your category field, such as Country, into the Values field.
4. Optional: Drag another metric, like Population, to the Size field to make the bubbles change size.
5. Finally, add your Play Axis slicer and hook it up to your Year column.

When you press play, you'll see the bubbles for each country move across the chart as their life expectancy and GDP evolve over the years. It's a stunningly effective way to visualize decades of global development in seconds.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

Control Which Visuals Animate

What if you only want the Play Axis to animate one specific chart on a page full of visuals? By default, a slicer affects everything. You can change this behavior easily.

1. Select your Play Axis slicer.
2. Go to the Format tab in the main Power BI ribbon at the top of the screen.
3. Click on Edit interactions.
4. You'll see small filter and "none" icons appear on the top right corner of every other visual on the page.
5. For any visual you don’t want to be animated, simply click the (None) icon.

This tells the Play Axis slicer to ignore that visual, keeping it static while others on the page animate.

When Not to Use Animation

While powerful, animation isn't always the right choice. It's meant to clarify, not confuse. Here are a few things to keep in mind:

• Avoid Overkill: Not every chart needs to be animated. If time isn't a meaningful dimension for your data, adding a play axis just adds clutter. Reserve it for stories that truly unfold over time.
• Keep It Purpose-Driven: Ask yourself: does this animation reveal an insight that a static chart would hide? If it's merely a gimmick, it can distract an audience instead of guiding them.
• Mind the Performance: On reports with a very large dataset or many complex visuals, animation can cause a performance lag. Always test your animated report to ensure it runs smoothly for your end-users.

Final Thoughts

Adding animation to your Power BI reports using the Play Axis visual is a fantastic way to tell compelling data stories and reveal insights that might otherwise go unnoticed. By visualizing how your metrics evolve over time, you transform dashboards from static pictures into dynamic narratives that capture attention and clarify complex trends.

While creating these kinds of interactive reports in Power BI is powerful, we know that getting all your marketing and sales data into one place for analysis can often be the most time-consuming step. We created Graphed because we wanted to eliminate the manual work of connecting data sources and building reports from scratch. Instead of digging for slicers and configuring visuals, you can just ask a question in plain English like, "show me a dashboard comparing sales by region over the past two years," and get a live, interactive dashboard instantly.