topic Re: How to create a waterfall chart from measures in DAX Commands and Tips

How to create a waterfall chart from measures

Anonymous — Tue, 06 Aug 2024 12:08:17 GMT

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 — Tue, 06 Aug 2024 21:06:11 GMT

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

Anonymous — Wed, 07 Aug 2024 06:39:21 GMT

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 — Wed, 07 Aug 2024 16:58:04 GMT

Prepare your data in a usable form, something like this

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