2024 Week 2 | Power BI: Soda Pop Sales in a Jittered Column Chart

Power BI, Workout Wednesday / By

Introduction

This week we have our first guest post of 2024! Today’s challenge comes from Imran Haq (LinkedIn, X). I have always admired his Deneb skills, so I’m excited to share this report with you today. We are making a jittered column chart with Deneb. The theme of soda (or pop, coke, or whatever you call it where you live) adds an extra element of fun, since the jitter marks look like bubbles!  We hope you’ll enjoy giving this one a try. It is a great example of a sophisticated design that requires a flexible custom visual like Deneb to achieve in Power BI. 

Requirements

  1. Import the data from Data.World using your method of choice. Note: There are 3 files in the project. You just have to choose one of them. We get options this week as to your preferred data format.
  2. Create a custom column called Sales Revenue The formula should be:
    [Unit Cost] * [Sold Items].
  3. Create and expand a nested list containing 1 row for every item sold, this will be the OrderID for each product.
    Table.AddColumn(
    col_sales_revenue, “OrderID”,
    each {1 .. [Sold Items]}
    )
  4. Ensure the OrderID column is set to “Do Not Summarize” in the model. 
  5. Don’t forget to format the data types appropriately!
  6. Create 3 measures: Sales, Orders, Unit Cost.
  7. Create a jittered column chart using Vega-Lite in the Deneb custom visual. Each type of soda should be represented by a column. The column length should represent the Sales Revenue total. Label each bar with the Sales Revenue and Unit Cost. Create a circle mark inside each bar for each unit sold, distributing the marks across the range of the bar’s Sales Revenue value. Highlight the best and worst sellers based upon number of the Sold Items (number of items sold).

Dataset

You can find this week’s data on Data.World at https://data.world/mlongoria/wow2024w2. Data.World requires you to create a free account to access the data. You may use the Data.World connector in Power BI or download the file to your local machine and connect to it there. 

There are 3 files in the project. You must choose ONE of them. They are the same data in 3 different formats. Use whichever file you prefer, or manually enter the data in Power BI Desktop.

Share

After you finish your workout, share on Twitter using the hashtags #WOW2023 and #PowerBI, and tag @Haquafresh, @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 the data stories gallery.

Scroll to Top