How it works...

In step 1, we create a line chart with one dimension and one measure and then apply Running Total Table Calculation in step 2. In step 3, we then change the mark type to Gantt Bar. In order to create bars, in step 4, we negate the measure so each column can grow to the previous mark. This creates the stair step effect, so the end of one mark is the beginning of the previous one. We see in step 5 that we've created a basic waterfall chart.

In order to highlight the positive or negative change, we create a Dual Axis chart. In step 6, we duplicate the same measure on the Rows shelf. We clear the size from the second Marks card in step 7, which will emphasize the ending value when we make the dual axis in step 8—causing the marks to overlay. In step 10, we add a total to show the cumulative impact of all values. Finally, in step 11, we change the default mark type to Gantt Bar to emphasize the negative or positive change.