2026 Week 29 | Power BI: Peas, Pods, & Pivoting

/ Power BI, Workout Wednesday / By

Introduction

One of the first “unique” chart types I ever learnt to visualise in a BI tool has since become one of my favourites, the Peas-in-a-Pod chart.

This chart can be a great way to visualise the change between multiple data points. For example, in this challenge, we will be exploring how the IMDB ratings for some of cinema’s most famous 4-film franchises varied across their respective franchises.

This challenge will involve not only creating the peas-in-a-pod chart but also transforming the data into the chart’s required structure.

Have fun, and I hope you fall in love with this chart type just like I did.

Dataset

The data set can be obtained from GitHubhttps://github.com/Imba456/Workout-Wednesday-for-Power-BI/blob/main/datasets/Film_Franchises_WOW_Dataset.csv

Requirements

  1. Download the data from the CSV file and bring it into Power Query.
  2. Transform the data structure for use in a ‘peas-in-a-pod’ chart.
  3. Build the peas-in-a-pod chart.
  4. Order the pods by total franchise box office.
  5. Create a legend.
  6. Create a tooltip report that contains a table showing the following fields: Color, Franchise, Title, Year, Rating, Box Office. Use that as the tooltip for the peas-in-a-pod chart. 

Hints

  1. Sometimes, to pivot, you have to unpivot first
  2. Error bars are your friend
  3. Each pod casing should contain the highest and lowest rated title in each franchise
  4. Here are the hex codes if you wish to follow the formatting in the example: 
    • 1: #981F26
    • 2: #CF7926
    • 3: #5197B9
    • 4: #098A74 

Share

After you finish your workout, share on BlueSky or LinkedIn using the hashtags #WOW2026 and #PowerBI, and tag @MMarie, @shan_gsd, @KerryKolosko (on BlueSky). Tag Tobin Hardy on LinkedIn. 

Solution

Solution File

Download from the Data Stories Gallery