Forum Discussion

Kpower's avatar
Kpower
Frequent Visitor
9 years ago
Solved

Last & Days Waterfall Chart

Hi,

 

I need to create a waterfall chart for the Amounts for last seven days, this filter should change dynamically.

Can you let me know the solution for this.

 

Thanks

Need Help
  • Anonymous's avatar
    Anonymous
    9 years ago

    Hi Kpower,

     

    You can also create a calculate table which filtered with last seven days, then use the filtered table as the source of waterfall chart'.

     

    Sample:

     

    Table 2 = FILTER(ALL(Table),[Date]>=LASTDATE(VALUES(Table[Date]))-7)

     

     

    Regards,

    Xiaoxin Sheng

5 Replies

  • Vvelarde's avatar
    Vvelarde
    Icon for Community Champion rankCommunity Champion
    9 years ago

    Kpower

    hi, you can show the values in the last 7 days with this:

     

    ValueShow = if(VALUES(Table1[Date])>TODAY()-7;CALCULATE(SUM(Table1[Value]));BLANK())

     

    • Kpower's avatar
      Kpower
      Frequent Visitor
      9 years ago

      Vvelarde

       

      Hi,

      I'm getting error for this.

      ValueShow = if(VALUES(DAILYTRANSACTIONS[TRANDATE])>TODAY()-7, CALCULATE(SUM(DAILYTRANSACTIONS[Amount])) ,BLANK())

      Can you take a look at it.

  • Anonymous's avatar
    Anonymous
    Not applicable
    9 years ago

    Hi Kpower,

     

    You can also create a calculate table which filtered with last seven days, then use the filtered table as the source of waterfall chart'.

     

    Sample:

     

    Table 2 = FILTER(ALL(Table),[Date]>=LASTDATE(VALUES(Table[Date]))-7)

     

     

    Regards,

    Xiaoxin Sheng