2025 Week 19 | Dumbbell chart plus

Introduction

Welcome back to Workout Wednesday!  This week we’re building a special three-way dumbbell chart!
You may ask, if this is a fixed term?
No – I just think that sometimes there are three values that need to be displayed.
This is how it will look like – you can easily see that chocolate prices are way up since 2015, especially in Hungary and Lithuania.

Want to learn, how to creat a chart like this?
Let’s do it!

Requirements

  1. Download the sample data from the Data World Website.
  2. Create a clustered bar chart with the three price indices on the x axis and country on the y axis.
  3. Make all bars overlap and transparent.
  4. Create markers via error bars.
  5. Add data labels for the 2015 and 2025 series.
  6. Create an informative tooltip.

Dataset

This week’s data is once again about the consumer price index for chocolate in different European countries since 2015 (Source: ECB Data Portal). The sample data can be found on the data.world website here. Note: Data.World requires you to create a free account to access the data, please sign in to see and download it.

Share

After you finish your workout, share on social media using the hashtags #WOW2025 and #PowerBI. Tag me (Diana Ackermann) on LinkedIn, along with MeaganKerry, and Shannon.

On Bluesky, tag @mmarie.bsky.social, @shan-gsd.bsky.social, and @merrykerry.bsky.social.

Solution

You can find a detailed video on how to create this chart here.

Leave a Comment

Scroll to Top