MicroStrategy ONE

Create a Waterfall Chart

Use the Waterfall Chart to visualize the cumulative effect of sequentially introduced positive and negative values. Columns and colors can show how an initial value is affected by a series of intermediate positive and negative values. Click here to see an example.

To convert a Waterfall Chart built on MicroStrategy 10.11 through version 2020:

  1. In the Waterfall Options section of the Format panel, change the calculation mode to Show Difference.
  2. Switch to another visualization type and then choose the Waterfall Chart type again.
  3. If you choose to switch back to the Show Sum calculation mode, you will still retain the latest version

  1. Open a dashboard.
  2. In the top toolbar, click Insert Visualization .

  3. Choose More > Waterfall .

  4. In the Datasets panel, double-click attributes and metrics to add them to the visualization. A waterfall chart requires at least one attribute and one metric.
  5. In the Format panel, select Waterfall Options from the first drop-down to modify formatting options, specific to waterfall charts.

  6. Choose to color the starting point statically or dynamically (by increase or decrease). In the Text and Form tab of the Format Panel, under Start point, choose Auto. You can always reset back to a static color with the Reset button.

Example Waterfall Chart