You can use the variance waterfall chart (Variance waterfall) to show the variance between two measures over the different values of a dimension. The variance waterfall chart is included in the Visualization bundle.
You need to use two measures, start value and end value, and one bridge dimension.
Creating a variance waterfall chart
You can create a variance waterfall chart on the sheet you are editing.
Do the following:
- In the assets panel, open Custom objects >Visualization bundle and drag a Variance waterfall object to the sheet.
Click the Add dimension button to select the bridge dimension.
- Click the first Add measure button to select the measure to use as start value.
- Click the second Add measure button to select the measure to use as end value.
The variance waterfall chart is now displayed with one bar for the start value measure and one bar for the end value measure. Between the measure bars you will see the variance for each value of the bridge dimension.
Changing the appearance of the chart
You can customize the appearance of your chart.
You can turn off value labels by setting Appearance > Presentation > Value labels to Off.
You can customize the legend labels by setting Appearance > Presentation > Labels to Custom. You can set a custom text for the following legend labels:
- Start value (Start value)
- End value (End value)
- Positive variance (Positive label)
- Negative variance (Negative label)
You can also hide the legend by setting Appearance > Colors and legend > Show legend to Off or change the position of the legend with Appearance > Colors and legend > Legend position.
For information about general limitations, see Creating a visualization using a custom object.
- It is not possible to use a variance waterfall chart in a Trellis container.
- You need to use the same number format for both measures to get correct number format for the dimension variance bars.