Introduction
Welcome back to Workout Wednesday! This week we’re creating a dumbbell chart to compare 2 sets of values using Deneb! If this is your first time using Deneb I highly recommend you play around with either the Vega or Vega-lite languages in the online editor, where you can load the code from examples, amend it, and see what your changes do to the visual!
In this challenge, you’ll build a single dumbbell chart using Deneb and some fun sample data. Play around with your fonts, colors, and shapes to come up with a visual that works for you!
Meagan created a similar challenge in week 24 – check that one out for more info on comparing 2 sets of values using Deneb!
Requirements
Get and transform data
- Enter data in Power Query or grab it from the solution file
Product Year Units
SoldYear No Pirate Booty Year 1 500 1 Pirate Booty Year 2 600 2 Buccaneer’s Bounty Year 1 750 1 Buccaneer’s Bounty Year 2 900 2 Pirate Parrots Year 1 300 1 Pirate Parrots Year 2 450 2 Scurvy Snacks Year 1 900 1 Scurvy Snacks Year 2 800 2 Cannonballs Year 1 600 1 Cannonballs Year 2 700 2
Create your dumbbell chart
- Add the Deneb custom visual to your report
- Add the columns from your dataset into the values field well
- Start building! I used the Ranged Dot Plot sample from the Vega editor as my starting point
- Customize your formatting and add any fun graphics and text to your report.
- Ensure that all visuals meet the minimum standards of having alt text, that the tab order in your report makes sense, and that your color choices meet the minimum standards.
Dataset
This week’s challenge uses a made-up dataset that you can enter straight into Power BI.
| Product | Year | Units Sold | Year No |
| Pirate Booty | Year 1 | 500 | 1 |
| Pirate Booty | Year 2 | 600 | 2 |
| Buccaneer’s Bounty | Year 1 | 750 | 1 |
| Buccaneer’s Bounty | Year 2 | 900 | 2 |
| Pirate Parrots | Year 1 | 300 | 1 |
| Pirate Parrots | Year 2 | 450 | 2 |
| Scurvy Snacks | Year 1 | 900 | 1 |
| Scurvy Snacks | Year 2 | 800 | 2 |
| Cannonballs | Year 1 | 600 | 1 |
| Cannonballs | Year 2 | 700 | 2 |
Share
After you finish your workout, share on Twitter using the hashtags #WOW2023 and #PowerBI, and tag @MMarie, @shan_gsd, @KerryKolosko. Also make sure to fill out the Submission Tracker so that we can count you as a participant this week in order to track our participation throughout the year.
Solution
Solution File available for download via Data Stories Gallery.