04 Dec Create a Waterfall Chart in Tableau

A waterfall chart is a type of data visualization that shows how an initial value is affected by a series of positive or negative values. It is used to display the cumulative effect of multiple factors on a single metric, helping to identify the most significant contributors to the final result.

The waterfall chart would display:

• A series of bars, each representing a transaction
• The bars would be stacked on top of each other, showing the cumulative effect on the account balance
• The final bar would represent the ending balance

This visualization helps to:

• Understand how different transactions affect the account balance
• Identify areas where expenses can be reduced
• Make informed decisions about budgeting and financial planning

Let us see an example to create a Waterfall Chart in Tableau:

Let us create a Waterfall Chart to find the profit for each Sub-Category of the product.

We have created a new sheet with the name Waterfall Chart in the same Tableau project Amit_Tableau.twb.

Drag the fields to the respective pane:

1. Sub-Category dimension:  Drag to the Columns shelf.
2. Profit measure: Drag to the Rows shelf

The following is visible:

1. Added fields in Columns and Rows shelf in Tableau

Calculated Field

Now, right-click on the Profit field, click Create, and then Calculated Field:

2. Create a Calculated Field for a Measure field in Tableau

Now in place of Calculation1, mention -Profit for the calculation field.

We have added the expression -Profit in the calculation as well. Below the message is also visible i.e.
The calculation is valid. Click OK:

3. Set a new field for Calculation of a field in Tableau

The new field -Profit is now visible. Drag it to the Size shelf in the Marks card. After dragging, the following is visible:

4. Set a Size for the Profit field in Tableau

Now, right-click on the SUM(Profit) field in the Rows shelf. Click Quick Table Calculation, and select Running Total:

5. Set Quick Table Calculation and Running Total for a field in Tableau

Now, the appearance of the chart changes again.

After that, under the Marks pane, click Gantt Bar:

6. Set the Gantt Bar from the Marks pane in Tableau

The Waterfall Chart is now visible. Also, under the SUM(Profit) in the Rows self, the symbol is visible for calculation:

7. The Waterfall Chart created successfully in Tableau

If you liked the tutorial, spread the word and share the link and our website Studyopedia with others.

For Videos, Join Our YouTube Channel: Join Now

Read More:

• Get Data from Excel in Power BI
• Create a Gauge Chart in Power BI
• Create a Column Chart in Power BI
• Create a card in Power BI
• Format the cards in Power BI
• Update the cards in Power BI
• Create a Table in Power BI
• Format the table in Power BI
• Table Conditional Formatting in Power BI
• Create a Filter in Power BI
• Create a slicer in Power BI
• Select multiple values from a slicer in Power BI
• Set a chart with a slicer in Power BI