Waterfall Chart Not Showing Decreases

[alecw044]

Hello,

I am trying to create a waterfall chart which would show the increases/decreases from a value from month to month. Currently, I can only get it to where it is adding the values from the previous month instead of showing as a decrease if the value is smaller. How can I fix this?

 

Thanks,

Alec

EDIT: I found that it will show as a 'decrease' if the value is negative. How can I get it to show a decrease if the value in column 2 is less than value 1, but not a negative number? For example, if the value in column 1 is 10 and the value in column 2 is 8, I would like the waterfall chart to show a decrease of 2.

[v-piga-msft · Accepted solution]

Hi @alecw044,

You should drag an other field to Breakdown so that it will show the Decrease. 

In addition, you could calculate the difference for the Count of Assets and create the waterfall chart.

difference =
CALCULATE (
 MAX ( 'Table1'[Count] ),
 FILTER ( ALL ( 'Table1' ), 'Table1'[Month] = EARLIER ( Table1[Month] ) + 1 )
)
 - 'Table1'[Count]

More details, you could have a look at this document.

If you still need help, please share some data sample and your expected output.

Best  Regards,

Cherry

[Black_magic100]

Hey I am trying to achieve exactly this, but how would I incorpoirate my date table?  Whenever I try and use the date column after the EARLIER function I just get red squiggly lines and I have no idea why