Waterfall chart help

[jacobHW]

Hello experts,

I am not able to transform the following data into a waterfall chart in PowerBI. Please help. I tried everything and also searched in youtube but no luck

Category	Amt
Start	$10,000
Change 1	($1,530)
Change 2	($388)
Change 3	($496)
Change 4	($200)
Change 5	$601
Change 6	($101)
Change 7	($200)
Change 8	($118)
Change 9	$470
Change 10	$200
End	$8,238

I want it to be like the below excel waterfall chart which is so much easier

[jacobHW]

Thanks it works. only issue is that the starting point/bar is green which denotes increase. There is no option to change the color.

[DataInsights]

@jacobHW,

You can set the color of starting/ending bars in Bar Color --> Total:

[jacobHW]

It just changes the end bar. Its taking the starting bar as increase

[DataInsights · Accepted solution]

@jacobHW,

Try the Simple Waterfall visual:

https://appsource.microsoft.com/en-us/product/power-bi-visuals/WA200000195