Forum Discussion
Help to create MOM comparative waterfall chart
Hello all, firstly thanks for all your support. I have a dataset (flat table format) which includes products, months and values. ie: There are products that: change values mont...
You can get it to work if you summarise your totals in a separate table then use this table to produce your waterfall - the total is automatic and will equal your August total.
| Category | Total |
| 1 July 17 | 302 |
| 2 Deleted | -65 |
| 3 Change | 82 |
| 4 New | 58 |
Thanks, yet I'm trying to have a formulated approach for this instead of a summarized table since I would like to use "Product" as a 2nd level category within the waterfall to be able which products were the drivers of this MOM changes, if I do a summarized table then I would lose this possibility
I have to point out that's not what you originally asked for, and I don't think it's possible to produce a drillable waterfall chart in Power BI but happy to stand corrected.