Forum Discussion
How to create waterfall chart
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
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.
1 Reply
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.