How to
Waterfall Chart Steps
Control how each bar of a Waterfall chart moves — set a starting bar, subtract costs, and show subtotals or a final total such as EBITDA.
Updated November 18, 2026
A Waterfall chart shows how a starting value changes step by step. For example, Revenue minus Opex, People and other costs, ending at EBITDA. Each bar starts where the previous one ended.
Set up a bridge (e.g. Revenue → EBITDA)
- Open the widget and set the chart type to Waterfall.
- In Visualization → Axis, pick the category column (e.g.
label) for X Axis and the amount column for Y Axis. - Expand Steps and set Bar direction to First bar is the start, others subtract. The first bar is drawn in full and every other bar steps down from it, even when your amounts are positive.
- Under Bar roles, set the result row (e.g. EBITDA) to Total. It is drawn from zero and shows what is left.
If your data has no result row, switch on Add total bar at the end and give it a name such as EBITDA.
Bar roles
Each bar has one role. Pick it under Steps → Bar roles; Auto follows Bar direction.
| Role | What the bar does |
|---|---|
| Start | Sets the starting level (drawn from zero). |
| Increase | Adds its amount and steps up. |
| Decrease | Subtracts its amount and steps down. |
| Subtotal | Marks a checkpoint: the bar spans from the previous subtotal (or zero) to the running total so far, and is labelled with that running total. The steps continue after it. |
| Total | Shows the running total so far, from zero. |
For Increase and Decrease the role sets the direction and the amount's size is used, so a cost can be stored as 300 or -300. Subtotal and Total are labelled with the calculated running total, not the value in that row.
With Bar direction set to From value sign, positive values go up and negative values go down. This is the default, so existing charts look the same.
Order matters
ORDER BY so the start comes first and the total comes last.Colors
In Style → Waterfall Colors, choose a color for Start, Increase, Decrease, Subtotal and Total. Pick a theme color or type any hex code (e.g. #1d4ed8).
Below zero
When costs are larger than the starting value, the bars continue below zero and the Y axis extends below zero automatically. Set Axis → Min Value to fix the axis yourself.
A type column in your data with the values start, subtotal or total still works. A role picked under Bar roles wins over it.