How to create a waterfall chart from measures

[Anonymous]

Hi There,

I need to create a waterfall based on the data I already calculated as a measure.

So increases/decreases between subsequent months.

[lbendlin]

Sounds good. What have you tried and where are you stuck?

[Anonymous]

Hi, 

So let me provide you the explanation:

There is 2 data tables:

Input:

April|May|June

1128|1167|1165

Output:

April|May|June

1158|1183|1184

So the first difference I calculated is diff between Input current month and Output Previous Month. Second difference is Output-Input

The total is Output value from previous month.

[lbendlin · Accepted solution]

Prepare your data in a usable form, something like this

and then use that in the waterfall chart, similar to this.