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)

  1. Open the widget and set the chart type to Waterfall.
  2. In Visualization → Axis, pick the category column (e.g. label) for X Axis and the amount column for Y Axis.
  3. 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.
  4. 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

Bars appear in the order your query returns rows. Add an 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.