Creating a Waterfall Chart with a Second Dimension on Color

Published: 18 Jul 2013
Last Modified Date: 20 Jul 2023

How to create a waterfall chart with a second dimension on color.

Tableau Desktop

Using the Example dataset called Superstore, which comes for with the Tableau Software, follow the steps below:

Drag the first desired dimension to the Columns shelf.
Drag the desired measure to the Rows shelf.
Right-click the measure and select Quick Table Calculation > Running Total.
Drag the second desired dimension to the Color shelf.
On the Marks card select Gantt Bar from the mark type drop-down menu.
Go to Analysis > Create Calculated Field... and create a calculation similar to the following:
```
-sum([Measure])
```
Drag this new calculate field to the Size shelf.
From the Rows shelf, right-click on the measure and select Edit Table Calculation....
Under Compute Using... select Specific Dimensions, and check the boxes next to both dimensions.
Close the Table Calculation window.