Forum Discussion
Waterfall Chart Not Showing Decreases
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.
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
2 Replies
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
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
