Forum Discussion
Help with simple waterfall chart
Hi Im trying to create what I thought was a pretty simple waterfall chart but I cant quite get it to turn out how Id like.
I have my 2020 budget and then a series of revenue iniatives that get me to a proposed 2021 number:
| 2020 Budget | $ 1,000,000 |
| Revenue Iniative 1 | $ 500,000 |
| Revenue Iniative 2 | $ 200,000 |
| Revenue Iniative 3 | $ 50,000 |
| Revenue Iniative 4 | $ 300,000 |
| Revenue Iniative 5 | $ 250,000 |
| 2021 | $ 2,300,000 |
When I drop this data into POwer BI and create my waterfall, it shows the 2020 Budget as a movement. Is there are way to show it as a starting point with the revenue iniatives building up to the 2021 ending point?
Thanks!
Hi,
Here is a screenshot of how it would look if you use Simple Waterfall
You can download the sample file from here
4 Replies
Hi Anonymous ,
Using this type of data place the Category column on the Category, Y Axis Values. Then filter out the 2021 value and sort the information ascending by the Category column should give expected result:
- Have you tried the custom visual Simple Waterfall. It will do the job
