Hello all, firstly thanks for all your support.
I have a dataset (flat table format) which includes products, months and values.
There are products that:
from this data set, I would like to create a waterfall chart that shows the variation MOM by "variation type"
I'm attaching the example excel file... I'd REALLY appreciate your help on how to do this.
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.
|1 July 17||302|
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.