Help with simple waterfall chart

[Anonymous]

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!

[MFelix]

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:

[Anonymous]

Thank you, is there a way to change the Total to show as 2021?

[Nishantjain · Accepted solution]

Hi, 

Here is a screenshot of how it would look if you use Simple Waterfall 

You can download the sample file from here

[Nishantjain]

Have you tried the custom visual Simple Waterfall. It will do the job