Following The semantic Rulebook of IBCS®, a variance analysis can also be performed with both the Ultimate Waterfall Chart Custom Visual and the Ultimate Variance Chart Custom Visual In Microsoft Power BI.
1 Ultimate Waterfall Chart with Subtotal and Deviation Analysis Table
A 3-Level but very simple profit and loss statement is displayed here. Next to the account, the current ACTUAL value is displayed in the first column. In the chart header (Actual), the column names are highlighted with bars around the current year or similar. In the next column the plan value for the current year is shown, highlighted with a white bar to color the aspect of the future. In addition to the absolute deviation, the percentage deviation is also shown in the table. Each individual column can be shown or hidden. The waterfall Chart which is integrated in the table can optionally display only the actual values or the plan values as a reference. Both the text of the label on the bars and the numbers in the table can optionally be visually highlighted with the associated sentiment color, depending on whether they are in the positive or negative orientation. The column width of the table automatically adapts to the length of the column name.
You can navigate through the multi-level accounts hierarchy either via the two large icons (+/-) in the upper left corner of the Chart, or directly on an account group. By repeatedly pressing the hierarchy symbol (left old Chart header, or right new Chart head up in the Chart to find), the navigation is first 
turned on. The sum of all operations of the button generally defines the number of levels that can be navigated with the symbols (+/-).
2 Ultimate Waterfall Chart for time series analysis
For time series, it is best to use a horizontal orientation of the X-axis. The following Chart shows each access and exit of a key figure and visualizes the total at the end with the total column. The Chart offers a lot of settings, such as additionally displaying a line of the result of the entries and exits. Furthermore, the colors can be changed or it can be defined which labels are displayed at which position.
|
Gain and Loss
|
Gain and Loss with Line (Result)
|
3 Ultimate Variance Chart with subtotals and deviation analysis Table
Similar to the first post in this article, a deviation table with basically the same functionality as the Ultimate Waterfall Chart (Multi Level Hierachy drill down). The first Chart itself is here but a combined column which can basically show 3 values. IS value, target value and deviation. This first Chart is called base Chart, it can be combined with other Charts from the series. In this case, the percentage deviation from budget and plan to the actual values is shown with a lollipop Chart. Alternatively one or two Charts can be displayed, even for absolute values. Further combinations with deviation Charts for absolute and percentage values are possible.
4 Ultimate Variance charts and tables accumulated (beginning of year to current period)
Similar to the previous section, but without total because it is a cumulative view of the data. It’s a pity that you should use a horizontal axis for time series, but demo data does not allow any other screenshots
 |
 |
5 Ultimate Variance Chart – Column in column with accumulated total column
The time series ends with an equally scaled total column. If the Chart is not already overloaded, there is still the option to further compress the information. By graphing another key figure like the previous year next to actual and target values. Alternatively, it is also possible to display a contribution margin in% instead of the previous year, for example. This key figure is displayed on a second Y axis, ie scaled differently.
|
|
 |
6 Additional highlighting of deviations in absolute and percentage numbers
Freely definable start and end points for up to 2 highlight arrows. The deviation is calculated automatically, it can be switched directly from the absolute to the percentage deviation with a click in the Chart.
 |
|
7 Small Multiple Table Waterfall Charts
Small Multiple Waterfall Charts (Small Multiples) or Multi Variant Reports. The advantage is obvious, Compare the same with like: The Charts scale the same and it is ensured that there are no distortions. The values of the values or Charts can be compared visually.
8 Small Multiple Variance Chart
This Chart is available in all possible combinations. See also section 7.
9 Ultimate Waterfall chart and tables as well as vertical Actuals and reference column as Chart
The following Chart shows the access and exit of a key figure and visualizes the total at the end with the Total Pillar (Net Result). The reference or exit bar is not particularly suitable for comparisons against plan or goals, but for many other cases with access and exit in the period or category. This illustration, too, is due to the demo data and in the current context is not 100% suitable in terms of content. ?
You can read more here in case…
Views: 5688