How to create waterfall chart

[frankhofmans]

Hello,

i have a table with prospect and the actions taken:

Prospect ID	Prospect called	Prospect reaction
812	Y	Not interested
813	N
814	Y	Contract signed
815	N
816	Y	Not interested
817	Y	Appointment made, prospect is not interested
818	Y	Not interested
819	N
820	Y	Contract signed
821	Y	Contract signed, but rejected by prospect
822	Y	Appointment made, prospect is not interested
823	Y	Not interested
824	N
825	Y	Contract signed, but rejected by prospect
826	Y	Contract signed

I want to create the following waterfall chart:

It's easy in Excel, but i can't create this in Power BI. Can you guys help me out?

thanks in advance!

Regards, Frank

[V-lianl-msft · Accepted solution]

Hi @frankhofmans ,

Unfortunately, there are no perfect solutions for the time being. You can try these alternatives.

See if the "simple waterfall" visual can meet your need.

You can also try to use a bar chart with a transparent background to overlay it.

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