Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
9 years ago

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:

  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*

Need Help
Show and Tell
Tips and Tricks
Tutorial Requests

5 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    9 years ago

    hello, any ideas??

     

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

     

    THANKS!

  • shill1000's avatar
    shill1000
    Helper IV
    9 years ago

    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.

     

    CategoryTotal
    1 July 17302
    2 Deleted-65
    3 Change82
    4 New58

     

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      9 years ago

      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's avatar
        shill1000
        Helper IV
        9 years ago

        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.