Highlight Metric Value Changes in a Waterfall Chart
Visualize how a key value evolves over time or across categories by showing the
cumulative effect of both positive and negative changes in a waterfall chart. This chart type,
based on a bar chart, is ideal for highlighting the net effect each individual value has on the
final value. For example, using your sales order data, create a waterfall chart to compare how
each business region contributes to total profit.
Tableau Unmetered Platform Analyst or Tableau Next Platform Analyst permission set
From the Data pane in your visualization, drag the dimension field used to analyze the
measure onto Columns. For the chart in the example, select
Region.
Drag a measure field, such as Sum of Profit, onto
Rows.
To show the cumulative aggregate of the measure over time or across categories, from the
measure field’s context menu, select Quick Table Calculation >
Running Total.
To visualize decreases in the measure’s value alongside increases, add a calculated field that returns the negative of the
measure.
Drag the calculated field onto the Range encoding to show the
cascading effect of the measure values.
Optionally, you can add more details to the waterfall chart.
For example, to view the value of each bar, drag Sum of Profit
onto the Label encoding.
To view each bar in a different color, drag Sum of Profit onto the
Color encoding. To apply custom colors, such as green for profit and
red for loss, use a calculated field that returns discrete values for colors.
We use three kinds of cookies on our websites: required, functional, and advertising. You can choose whether functional and advertising cookies apply. Click on the different cookie categories to find out more about each category and to change the default settings.
Privacy Statement
Required Cookies
Always Active
Required cookies are necessary for basic website functionality. Some examples include: session cookies needed to transmit the website, authentication cookies, and security cookies.
Functional Cookies
Functional cookies enhance functions, performance, and services on the website. Some examples include: cookies used to analyze site traffic, cookies used for market research, and cookies used to display advertising that is not directed to a particular individual.
Advertising Cookies
Advertising cookies track activity across websites in order to understand a viewer’s interests, and direct them specific marketing. Some examples include: cookies used for remarketing, or interest-based advertising.