Solved: Last & Days Waterfall Chart

Kpower · ‎01-10-2017

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

v-shex-msft · ‎01-12-2017

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

Community Support Team _ Xiaoxin
If this post helps, please consider accept as solution to help other members find it more quickly.

klabir · ‎04-16-2017

Have a look at the PowerBI Ultimate Waterfall Chart

v-shex-msft · ‎01-12-2017

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

Community Support Team _ Xiaoxin
If this post helps, please consider accept as solution to help other members find it more quickly.

Vvelarde · ‎01-10-2017

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())

Lima - Peru

Kpower · ‎01-10-2017

@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.

Vvelarde · ‎01-10-2017

what is the error message?

Lima - Peru

Last & Days Waterfall Chart