Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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!
Solved! Go to Solution.
Hi,
Here is a screenshot of how it would look if you use Simple Waterfall
You can download the sample file from here
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:
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsThank you, is there a way to change the Total to show as 2021?
Hi,
Here is a screenshot of how it would look if you use Simple Waterfall
You can download the sample file from here
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
109 | |
98 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
100 | |
86 | |
64 |