Animated Bar Chart In Power BI

Overview

As we all know, Power BI is a great visualization tool. Power BI supports custom visualizations from their App source. In this article, we will cover how to create an animated bar chart with its all configurations and properties.

At the end of the article, we will be able to create the Animated Bar Chart, like the following.

Download Code and Sample Data Source

You can download the Power BI file and sample data source file using the following URL.

So, now let’s get started!

Step 1

Download Custom Visualization using the following link.

https://appsource.microsoft.com/en-us/product/power-bi-visuals/WA200000053?tab=Overview

We can download it from Microsoft App source as well.

Search for “Animated Bar Chart Race” and it shows the following result. Add the visualization.

Step 2

We have the following data structure. We have different sales data by person, by year.

We have three columns.

Business Man
Year
Sales

We wish to represent that data in our Power BI report.

Step 3

Add the “Animated Bar Chart Race” visualization in the Power BI report.

Now, we need to configure the following properties.

Name
Value
Period

Step 4

Drag the following columns from the source data.

Name = Business Man

Value = Sales

Period = Year

Step 5

Once we configure the properties, we can see an animated bar chart something like in the following screenshot.

The real demo can be viewed using this link, so you will get the better idea of the functionality of the visualization.

Step 6

Now, let’s check its important properties.

The most important configuration setting is “Wishyoulization Settings”.

Step 7

“Wishyoulization Settings” has the following configuration settings.

Top n = Number of Top entities which we wish to represent in the chart. Let’s say in my case we wish to represent the top 10 Businessmen in every year.

Duration = Animated duration time for the bar in milliseconds.

Autoplay = If we don’t want autoplay and wish to represent chart as a normal bar chart, we can use this switch. But as per our opinion, we should turn AutoPlay on, otherwise, we can’t use the beauty of this visualization.

hideGrid = Hides the grid in the background

hideNumbers = Hides the numbers showing in the bar

hidePeriod = Hides the Period information from the bottom of the chart.

periodSize = This represents the font size of the period showing at the bottom.

Step 8

Now, let’s publish the report and the report will be animated like this.

Conclusion

This is how we can easily create an Animated Bar Chart in Power BI.

Isn’t it amazing?

Hope you love this article. Don’t forget to follow me for the amazing articles.