Introduction
Welcome back to Workout Wednesday! This week we’re building a stream graph in Power BI!
A stream graph is a variation of the stacked area chart that arranges categories so they flow above and below a central baseline. This creates a smooth, organic “stream” appearance. Stream graphs are excellent for visualizing how many categories change over time and for spotting peaks, trends, and shifts in volume. And beyond the analytical value, what a beautiful chart.
This technique is inspired by an approach taught by Sean Chandler at Sweatpants BI. Sean has a library of fantastic instructional videos on YouTube, and his guidance helped shape the process behind this build. The data source use for this build was obtained from the U.S Energy Information Administration .
For clarity and ease of learning, all measures in this report are named with alphabetical prefixes. This allows you to follow the workflow step-by-step as you build your own stream graph. The trick to creating this visual is in the disconnected table.
Let’s make some art!
Requirements
- Use the data from the starter file or import your own!
- Build a stream graph using a native stacked area chart visual
- Add a slicer to the canvas
- Adjust the formatting
As always, ensure your viz uses accessible colors, alt text, and tab order.
Dataset
Use the data in the starter file or download data straight from the source: U.S. Energy Information Administration – EIA – Independent Statistics and Analysis
Share
After you finish your workout, share on Bluesky or LinkedIn using the hashtags #WOW2025 and #PowerBI, and tag me (James), along with Meagan, Kerry, and Shannon.
On BlueSky tag the organizers @MMarie, @shan_gsd, @KerryKolosko (on BlueSky).
Solution
Download the solution file
Check out Sean’s video: