How to show Start and End Waterfall Chart

[mmaa12]

Hi,

I have the following table and I would like to use budget EBIT as a starting value and actual EBIT as an ending value, while the other values bridging between these two values. Could you someone help with this?

Name Value
Budget EBIT 100
Sales AB 10
Sales CD 10
Other income 10
Cost AB -10
Cost CD 10
Other cost 20
Actual EBIT 150

[v-jianboli-msft · Accepted solution]

Hi @mmaa12 ,

Please try:

First create an index column:

Then sort the name column by index column:

Change the visual's sort:

Final output:

Best Regards,

Jianbo Li

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