Skip to content
ALLURE
Skip to main content

Allure Analytics

Simple and variance waterfalls in a card

Use a running contribution story or a reference-to-Actual bridge in the card’s trend area.

Pick the arithmetic first

ModeFieldsMeaning
Simple waterfallTrend axis + ActualSigned contributions accumulate; Result anchors the balance
Variance waterfallTrend axis + Actual + referencePeriod changes bridge reference total to Actual total

Result and cost settings

Choose Waterfall IBCS, then the simple/running or variance mode. Assign Result or Cost change to the individual category where appropriate. These settings are saved independently per mode. A Result is an anchor, not an extra contribution. Already-negative expenses should not be inverted again.

A KPI Card with an IBCS waterfall, comparison rows and highlighted difference.

Click to enlarge.

When Actual stops before the plan

The variance waterfall’s default Treat missing side as zero keeps reference-only months as their own contributions. If July has Forecast 22.6M and blank Actual, the reference-to-Actual change is −22.6M. Source blanks remain identifiable; the card does not invent Actual.

Enable the Actual/Plan/Forecast separator to mark the first outlook period after the final observed Actual. Interior blanks do not create a transition. Keep gaps remains an available alternative. Genuine differences between model endpoints and displayed contributions can require a context adjustment.

Back to the Knowledge Base

Switch between card waterfall modes

Waterfall IBCS family and Simple/Variance mode chapter. This captured configuration continues trailing Actual with Forecast; its combined total differs from the Actual headline.

3840 × 2160 tutorial canvas at 20 fps. Real 2560 × 1392 Power BI Desktop screenshots retain their native size; this is a paced step sequence.

  1. Select the family — Under Trend chart, choose Chart type → Waterfall IBCS.
  2. Inspect Variance waterfall — Search for waterfall. Variance waterfall bridges from the reference with period differences; connectors and the final total are configurable.
  3. Choose Simple waterfall — Open Waterfall mode and select Simple waterfall (running).
  4. Read the running total — Each period adds to the running total. In this configuration, hatched periods are Forecast continuation, so the final total includes Forecast.

Download the 4K animated GIF · Download the 4K MP4