Inforiver

Upcoming webinar on 'Inforiver Charts : The fastest way to deliver stories in Power BI', Aug 29th , Monday, 10.30 AM CST.    Register Now

Dumbbell charts: Why is it a game changer?

Dumbbell charts provide an intuitive and effective way to visually compare two sets of observations. However, they are often overlooked due to their unfamiliarity. We will take a quick look at why dumbbell charts must be in your go-to repertoire of visualizations. 

Let us take a dataset consisting of GDP growth of a few countries. We want to compare GDP growth rate of two consecutive years (2021, the post covid recovery year, vs. 2022) to see which countries have sustained the expansion post COVID. 

When we plot it in a bar chart, the data shows up as follows. 

GDP growth rate in a bar chart 

However, when it comes to GDP growth data, we are often interested to know which countries are accelerating, and which ones are slowing down. In other words, whether a GDP growth of 3% is good or bad depends on the GDP growth in the prior period. If the prior period growth is 2.8%, then the economy is accelerating. If the prior period growth were 3.2%, it is a cause for concern. 

Looking at the bar chart, it is not easier to understand which countries have their rates accelerating vs. slowing down. Let us now try the same with a variance. 

GDP growth rate in a variance chart 

The integrated variance chart shown below is better than the bar chart. It quickly shows us that UK, France and Belgium slowed down much faster from the post-COVID recovery rates in 2021, while Portugal, UAE and Thailand sustained the expansion post-COVID.

Tracking Movement vs. Magnitude 

The integrated variance chart listed above tracks two things: 

  1. Magnitude of GDP growth rate in 2022 
  1. Movement of GDP growth rate  

In our case, we are more interested in tracking movement than the absolute magnitude. 

This is where dumbbell charts can help. It reduces the clutter introduced by plotting magnitude, and focuses more on the movement. Take a look at the chart below. 

Yes, the magnitude details are not lost, and they are still there. But the clutter is greatly reduced, and a larger emphasis is provided on the movement. 

Dumbbell charts are most used when we want to focus on movement rather than the magnitude of past and current values.   

You can still use dumbbell charts to plot variance, provided that you are keener on the variance than the magnitude of the achievement. 

Here is another great example of how a dumbbell chart can be used (source: www.policyviz.com). It not only shows two sets of countries – one where kids typically had higher math scores than reading scores, and another set of countries where the reading scores where better. In this example too, the exact math and reading scores are not as relevant as which score is better for a specific country. 


Get Inforiver brochure

Maximize your business potential with Inforiver's paginated reporting, data entry, planning & budgeting capabilities
Download now
Inforiver
About Inforiver!
Inforiver is the fastest way to do everything in Power BI. It enables citizen developer productivity and unleashes true self-service with our intuitive and interactive no-code data app suite for Microsoft Power BI. The product is developed by Lumel Technologies Inc, who are #1 Power BI Visuals AppSource Partner serving over 3,000+ customers worldwide with their xViz, Inforiver, and ValQ offerings.
Other Products
Inforiver Logo
IBCS Certified
Power BI certified

About Inforiver!

Inforiver is the fastest way to do everything in Power BI. It enables citizen developer productivity and unleashes true self-service with our intuitive and interactive no-code data app suite for Microsoft Power BI. The product is developed by Lumel Technologies Inc, who are #1 Power BI Visuals AppSource Partner serving over 3,000+ customers worldwide with their xViz, Inforiver, and ValQ offerings.

Headquarters
5920 Windhaven Pkwy, #130
Plano TX 75093
ValQ
xViz
BI Hub
linkedin facebook pinterest youtube rss twitter instagram facebook-blank rss-blank linkedin-blank pinterest youtube twitter instagram