Telling a Story with Power BI Waterfall Charts
Table of Contents
Introduction
When you are working with data, numbers alone are often insufficient to tell the whole story. This is where the Power BI Waterfall Chart helps. It visually breaks down the step-by-step impact of different factors, making the complex data easier to follow.
It helps your audience connect the dots in showing the sales variance, profit & loss or budget vs. actuals. Let’s build a Power BI Waterfall Chart from scratch, customise it for clarity, and add storytelling elements to make it truly impactful.
Understanding Waterfall Charts
Before we jump in, let’s recap:
- Purpose: Shows the starting value, sequential increases/decreases, and ending value.
- When to use: Budget vs. actuals, profit & loss analysis, revenue breakdown, variance explanations.
- Benefit: Makes trends and contributors crystal clear.
Prepare Your Data
A waterfall chart needs
- Category (Month, Department, Region, etc.)
- Breakdown (Product Categories)
- Y-axis (Sales, Profit, etc.)
Creating a Waterfall Chart in Power BI
For the sake of this tutorial, we will use a dataset from Kaggle ‘Monthly Sales Data of sell of electronics equipment across USA in 2019’.
Creating Required Measures
After you load and clean your data, you need to add some measures to your data.
- In Table View under Home Ribbon, select ‘New Measure’ under Calculations.
- In the DAX bar, write the following DAX formula for Total Sales.
Total Sales =
SUM ( ‘Data'[Sales] )
- Similarly, create another measure for Total Orders
Total Orders =
SUM ( ‘Data'[Quantity Ordered] )
This will give you two measures in your Data Table.
Add Data to The Waterfall Visual
Go to Visualisation Pane and click on Waterfall Visual to add it to your report page.
Now that we have our measures, let’s visualise our data by adding our data to the data buckets.
- Category: Here we will add Order Date.
This will show your order date in a hierarchical order, as shown:
We will visualise our data Quarterly, so go ahead and cross out other metrics, except ‘Quarter’.
- Breakdown: Add ‘Product’ to this bucket.
- Y-axis: Add the ‘Total Sales’ measure we made earlier to visualise total sales.
Alternatively, we can add ‘Total Orders’ to visualise orders.
Pro-Tip
If we take a close look at the Other category in the legend. What does this mean?
In the Table view, if we check, there are 19 product categories:
Visualising all the categories on the waterfall visual makes it cluttered; the “Other” category is created automatically when Power BI groups smaller contributors together, so the visual remains clean and readable.
This happens when you’re using a breakdown by category, but there are too many categories to display individually. Power BI will aggregate the least significant ones into “Other” based on their contribution to the total value.
We can adjust these in Format> Breakdown, here we can adjust the number of breakdown values as per our liking.
Adding Parameters
We can add a Parameter so that we can switch between Total Sales and Total Orders in the same visual.
- Go to Modeling Ribbon, in parameters select ‘New Parameter’, then select ‘Fields’:
- This will open a new window. Rename your parameter. Select ‘Total Orders’ and ‘Total Sales’ from the fields, make sure ‘Add slicer to this page’ is checked and hit create.
- This will create the following slicer:
- Now select your waterfall visual. In data buckets, in Y-axis, add parameters:
- Now you can switch between Total Sales and Total Orders easily in the same visual
List Slicer
If you still want to visualise other product categories other than the top 3 breakdowns. You can add a slicer to your visual. In Visualisation pane, select the ‘List Slicer’. In the Field Bucket, add ‘Product’.
- Visualization Pane> Visual> Slicer Settings> Single Select toggle it off.
- Now selecting the products from the list will show the Visuals for only those products. Remember that the visual has a breakdown of 3 values on it, so no matter how many products you select, it will show you the value for just the 3 metrics, all the other selected metrics will go in others category.
Here, we selected four products from the slicer, but the visual only views the Top 3 categories.
Formatting for Storytelling Impact
Here, we will do some formatting to make our visual stand out
- Go to Format >Visual.
- X-axis> Title toggle Off.
- Y-axis> Title toggle Off.
- Columns: Change colour as per your report theme.
- Data labels toggle On.
- Orientation Horizontal.
- Position Outside end.
- Background toggle On.
Our Visual should now look like:
Best Practices for Power BI Waterfall Charts
- Keep the Breakdown Manageable
Only show the most relevant categories. Too many breakdowns make the chart overwhelming.
- Use Consistent Colours
Assign green for increases, red for decreases, and a neutral colour for totals to help your audience instantly grasp the message. - Add Context with Tooltips
Customise tooltips to display extra information like percentage changes, margins, or related metrics. - Consider the Audience
Finance teams might prefer a profit/loss breakdown, while marketing teams might focus on sales growth drivers; design accordingly.
Real-World Examples of Waterfall Chart Usage
- Sales Performance Analysis
An electronics retailer uses a waterfall chart to show monthly sales changes across the year, highlighting which product categories contributed most to revenue growth. - Budget vs. Actual Spending
A project manager uses a waterfall chart to track budget variances, showing where costs increased and where savings occurred. - Profit Margin Breakdown
A manufacturing company uses it to explain how much raw material costs, labour expenses, and how operational efficiencies impact final profit. - Campaign Impact Review
A marketing team presents how different campaigns contributed to overall lead generation, increases from successful campaigns, and decreases from underperformers.
Conclusion
The Power BI Waterfall Chart is more than just a visual; it’s a narrative tool. By breaking down changes step-by-step, you help your audience understand not just what happened, but why it happened.
With thoughtful formatting, interactivity, and clear context, you can turn a simple chart into a powerful storytelling element in your reports.
FAQs
A Power BI Waterfall Chart shows how a value changes step-by-step, helping visualise sales trends, profit/loss, and budget variances clearly.
Add your Category (time, department), Breakdown (product/sub-category), and Y-axis measure (Sales, Profit, Orders) to the Waterfall visual in Power BI.
You need:
- Category: Month, Quarter, Region
- Breakdown: Product or service
Y-axis: Total Sales, Total Orders, or Profit
Use Top-N filters to show top-performing categories and List Slicers for custom product or department selections.
- Keep categories manageable.
- Use consistent colours (green for gains, red for losses).
- Add data labels and tooltips for context and storytelling.
Further Learning and Resources
To learn more about Power BI, check out our course here
ChatGPT Essentials for Data Analytics
Want to learn more about Power BI and how to make reports more efficiently?
- Power BI training in Australia: We offer comprehensive training sessions across various cities, including Sydney, Melbourne, Brisbane, and Canberra.
- Power BI Crash Course eBook: Download our detailed guide to take your Power BI expertise to the next level, covering topics from basics to advanced with practical examples and step-by-step instructions. (Limited time offer)
Download the Beginner’s Guide to Power BI
Ready to enhance your Power BI skills? Sign up for our training courses and explore our wide range of resources designed to elevate your data analytics capabilities.
Contact Us: Make an enquiry about our Power BI courses and find the proper training for you.
Are you a data analyst and want to learn more about Power BI?
Why not sign up for Power BI training in Australia. We provide our services in the following regions:
We offer comprehensive Power BI training across Australia, tailored to suit different learning styles and proficiency levels. We deliver all our training in collaboration with Dynamic Web Training.