Waterfall Chart

[yash_gaur]

I have a table like this - 

ID	Code
1	Initial
2	Initial
3	Intermed1
4	Intermed2

I want to have Code column as axis and count of ID column as values for my waterfall chart. The waterfall chart should show initial count as the starting balance, subtract intermed1 count from it and add intermed2 count to the resulting data to show the ending balance. So starting balance would be 2. To it intermed 1 would be subtracted (2-1). Then intermed2 will be added (2-1+1) to give the ending balance as 2. Right now the waterfall chart just adds intermed1 and intermed2 count to the initial count. Any thoughts on how to make it customizable ? 

Thanks in advance.

[v-kkf-msft]

Hi @yash_gaur ，

Has your problem been solved? If it is solved, please mark a reply which is helpful to you.

If the problem is still not resolved, please provide detailed error information or the expected result you expect. Let me know immediately, looking forward to your reply.

Best Regards,
Winniz

[v-kkf-msft]

Hi @yash_gaur ,

Please try the following formula:

Measure = 
IF (
    MAX ( 'Table'[Code] ) = "Intermed1",
    - COUNT ( 'Table'[ID] ),
    COUNT ( 'Table'[ID] )
)

If the problem is still not resolved, please provide detailed error information or the expected result you expect. Let me know immediately, looking forward to your reply.

Best Regards,
Winniz

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.