2026 Week 17 | Power BI: Create a Double-Sided Stem-and-Leaf Plot

Introduction

Inspired by a previous Tableau challenge, we are making a double-sided stem-and-leaf plot, but we are using a different dataset and showing the observed petal length of two species of iris. A stem-and-leaf plot displays numerical data by splitting each value into a “stem” (leading digit) and a “leaf” (trailing digit), arranging them so the distribution’s shape is visible. It preserves the actual data values while functioning like a histogram. This visual below was created using the HTML Content custom visual. 

Dataset

You can download the iris dataset from Microsoft’s Github repo here

If the Github link becomes unavailable, a copy has been saved to Data.World.

Requirements

  1. Connect to the supplied dataset. 
  2. Add columns to the dataset to create the correct values for Stem and Leaf.
    • Stem: The integer number to the left of the decimal in the petal length (cm) column
    • Leaf: The value to the right of the decimal in the petal length (cm) column
  3. Create a stem-and-leaf plot that shows the integer portion of the number in the stem and the decimal portion of the number in the leaf.
    • Plot the leaf values for the Iris versicolor on left side and the values for the Iris virginica on the right side. 
  4. Adjust the layout of the leaf circles so that there are multiple rows when there are more than 10 leaf values for the same stem value. 

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).

Solution