How to Create a Waterfall Chart in Power BI: Step-by-Step Guide

To create a waterfall chart in Power BI, select your data, then choose the Waterfall chart visual from the Visualizations pane. Add the category field to the Category area and the numeric field to the Y-axis area to show increases and decreases clearly.

Syntax

A waterfall chart in Power BI is created by selecting the Waterfall chart visual and assigning data fields to specific roles:

• Category: The labels or groups shown on the horizontal axis.
• Y-axis: The numeric values that represent increases or decreases.
• Breakdown (optional): Further splits categories into subgroups.
• Tooltips (optional): Additional info shown on hover.

This setup lets Power BI calculate the running total and display positive and negative changes as bars.

plaintext

Waterfall Chart Visual:
- Category: [Your Category Field]
- Y-axis: [Your Numeric Field]
- Breakdown (optional): [Subcategory Field]
- Tooltips (optional): [Additional Info Fields]

Example

This example shows how to create a waterfall chart to visualize monthly profit changes.

Assume you have a table with Month and Profit Change columns. You add the Waterfall chart visual, drag Month to Category, and Profit Change to Y-axis. Power BI then displays bars showing increases and decreases month by month.

plaintext

Table: MonthlyProfitChanges
Month,Profit Change
Jan,5000
Feb,-2000
Mar,3000
Apr,-1000
May,4000

Steps:
1. Insert Waterfall chart visual.
2. Drag 'Month' to Category.
3. Drag 'Profit Change' to Y-axis.

Output

A waterfall chart showing bars for each month:
- Jan: +5000 (up bar)
- Feb: -2000 (down bar)
- Mar: +3000 (up bar)
- Apr: -1000 (down bar)
- May: +4000 (up bar)
The chart shows cumulative profit changes over months.

Common Pitfalls

• Not assigning fields correctly: Forgetting to put the numeric data in the Y-axis or categories in Category causes the chart to not display properly.
• Using totals as data points: Waterfall charts calculate running totals automatically, so including total rows in data can distort the visual.
• Negative values confusion: Ensure negative values are correctly formatted as numbers; text or blanks can break the chart.
• Too many categories: Having too many categories can clutter the chart and reduce readability.

plaintext

Wrong:
- Category: Profit Change
- Y-axis: Month

Right:
- Category: Month
- Y-axis: Profit Change

Quick Reference

Step	Action
1	Select Waterfall chart visual from Visualizations pane
2	Drag category field (e.g., Month) to Category area
3	Drag numeric field (e.g., Profit Change) to Y-axis area
4	Optionally add Breakdown or Tooltips for detail
5	Format chart colors and labels for clarity

Key Takeaways

Always assign your category field to the Category area and numeric values to the Y-axis.

Waterfall charts show how values increase or decrease step-by-step with running totals.

Avoid including total rows in your data as Power BI calculates totals automatically.

Use clear labels and limit categories to keep the chart easy to read.

Customize colors to distinguish increases, decreases, and totals visually.