Create a variance chart

Create a variance chart.

Right-click on the waterfall chart to copy it, moving the copy to the right of the original. A new chart could be made instead. Copying a chart means all the account members are chosen, making it easier to change the colors.

On the new chart, change the chart type to absolute variance. Move the Year hierarchy to the Compare by section. Set the current year as the Base value and the previous year as the Comparison value.

In chart properties, hide the categories labels. This can be done by selecting the 'X' next to the label font editor under Titles and Axes.

Reduce the Y-Axis Text Width either in the layout properties or by resizing the chart.

In chart properties, under Format and the Axis Scales tab, choose the dropdown and set the Match to option to the first chart. This ensures that both the waterfall and absolute variance charts are plotted on the same scale, which is vital for accurate analysis.

The variance chart doesn't have a hierarchy set in Columns, so it doesn't show a header. This causes the bar size and spacing not to match the waterfall chart. To fix this, move the Measures hierarchy to Columns. This will display the header Amount - change this by right-clicking on the header and renaming.

Alternatively, hide the column labels in the waterfall by selecting Properties > Title and Axes > Column Font. Select the X to make it hidden.  

Add text in the cells above the charts. This will enable a dynamic header over the variance charts if needed.

Copy the absolute variance chart to the space to the right, and set the chart type to relative variance on the new chart.

Remove the Match to scale setting on the relative variance chart and update the header label to show %.