Forum Discussion
Waterfall chart issue
Hi Monica,
According to my test, the breakdown in the Power BI Waterfall chart exists in all milestones. Please check out the demo in the attachment. So the data could be like below.
Name Category Value
m1 start 10 m2 start 10 m2 Category 2 -2.13 m3 start 10 m3 Category 2 -2.13 m3 Category 3 0.6 m3 Category 4 0.2 m4 start 10 m4 Category 2 -2.13 m4 Category 3 0.6 m4 Category 4 0.2 m4 Category 8 3.6 Best Regards,
Dale
Good Morning,
Please find sample data below (sorry I have no idea how to attach excel)
| Name | Category | Value |
| Start | 10 | |
| Category 1 | 0 | |
| Category 2 | -2 | |
| Total 2 | 8 | |
| Category 3 | 0.5 | |
| Category 4 | 0.1 | |
| Total 3 | 8.6 |
I have tried to set it up in few different ways, but it did not work.
Will appreciate any help!
Thank you,
Monika
Hi All,
Sorry, sample data are like that (without total 3 since it's auto-calculated) :
| Name | Category | Value |
| Start | 10 | |
| Category 1 | 0 | |
| Category 2 | -2 | |
| Total 2 | 8 | |
| Category 3 | 0.5 | |
| Category 4 | 0.1 |
Thanks!
Hi Dale,
so maybe the problem is that i set up data wrongly.
Could you please advise me how it should be set up ?
I use PowerBI for some time, but i have never used waterfall chart unfortunately.
Thanks!
Monika
Basically, my data has some strating point let's say 10 and after that I have categories listed.
In between of categories I would like to see some milestones (totals) - that's why i set it up in this way.