Help to create MOM comparative waterfall chart

[decshz]

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:

1. change values month-over-month
2. products that were available last month but are no longer available current month
3. products that are available this month but were not last month.

ie:

from this data set, I would like to create a waterfall chart that shows the variation MOM by "variation type"

ie:

I'm attaching the example excel file... I'd REALLY appreciate your help on how to do this.

demo dataset link *here*

[shill1000]

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

[decshz]

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

[shill1000]

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.

[decshz]

hello, any ideas??

I'd appreciate any insights on how to begin to develop this.

THANKS!

[decshz]

@dedelman_clng

@v-qiuyu-msft

@v-sihou-msft

@v-caliao-msft

@v-chuncz-msft

@Vvelarde