Forum Discussion
Waterfall Chart using multiple measures
Hello, I know this must've been an old topic in Business Intelligence. However, I didn't find any idea to realize what I'd like to achieve. The thing is I'd like to create a Waterfall Chart ...
Anonymous How does this make it static?
For me based on this methodology, the columns in the waterfall shift based on whether the figures are accending or descrending. Can you share an example?
Cali_2020 - My waterfall category table is at the bottom. This table is named 'Waterfall Table'.
I built a custom column in the 'Waterfall Table' I call 'Waterfall Category'. This measure is the first field in my waterfall vizualisation 'Category' section.
Waterfall Category = IF('Waterfall Table'[Measure]="Total Generated Cash Flow",'Waterfall Table'[Measure],'Waterfall Table'[Gen. Cash Flow Adjustment Order]&": "&'Waterfall Table'[Measure])
I built a measure I call 'Waterfall Value'. This measure is the first field in my waterfall vizualisation 'Y Axis' section.
Waterfall Value =
Switch(
Selectedvalue('Waterfall Table'[Gen. Cash Flow Adjustment Order]),
1, +[EBIT @ Budgeted fx],
2, +[Cash used for Restructuring],
3, +[fx Impact],
4, +[Depreciation/Amortization],
5, +[Cash Generated from Change in Restruc. Accrual],
6, +[Cash Generated from Change in A/P],
7, +[Cash Generated from Change in Inventory],
8, +[Cash Generated from Change in A/R],
9, +[Cash used for Capex],
10, +[Total Gen. Cash Flow],
Blank()
)
'Waterfall Table':
| Measure | Gen. Cash Flow Adjustment Order | Waterfall Category | Short Measure Title | # & Short Title |
| EBIT @ Budgeted fx | 1 | 1: EBIT @ Budgeted fx | EBIT | 1-EBIT |
| Restruc. Expense | 2 | 2: Restruc. Expense | Res Exp | 2-Res Exp |
| Currency Impact | 3 | 3: Currency Impact | FX | 3-FX |
| D&A (Now at OPBDA) | 4 | 4: D&A (Now at OPBDA) | D&A | 4-D&A |
| Cash Generated from Change in Restruc. Accrual | 5 | 5: Cash Generated from Change in Restruc. Accrual | Res. Acc. | 5-Res. Acc. |
| Cash Generated from Change in A/P | 6 | 6: Cash Generated from Change in A/P | A/P | 6-A/P |
| Cash Generated from Change in Inventory | 7 | 7: Cash Generated from Change in Inventory | Inv. | 7-Inv. |
| Cash Generated from Change in A/R | 8 | 8: Cash Generated from Change in A/R | A/R | 8-A/R |
| Cash used for Capex | 9 | 9: Cash used for Capex | Capex | 9-Capex |
| Total Generated Cash Flow | 10 | Total Generated Cash Flow | TOT | Total |
Hope that helps.
hi
regarding the measure such as [fx_impact] where did you calculate them?
in order tables at the model? the Waterfall Table is just for collecting and arranging the data in order to create the waterfall?
