Forum Discussion
Waterfall Chart Help
Hi ggipson,
Based on my test, you could refer to below steps:
Sample data:
Create a Waterfall Chart and filter out the data in 2017. Now you could see the result.
You can also download the PBIX file to have a view.
https://www.dropbox.com/s/0y6j47zh0c5gcll/Waterfall%20Chart%20Help.pbix?dl=0
Regards,
Daniel He
Hi ggipson,
Could you please offer me the information about [COGS var] and the [Sales Var] and I also want to know the total should be 51 and you data showed as 18, how could you calculate it? Here is my result.
Regards,
Daniel He
Thank you for your response!
The margin (total) for the actual version for 2018 is 100 - 82 = 18
The margin (total) for the budget version for 2018 is 95 - 79 = 16The sales and COGS variances would just be the sales and cogs for the ending given scenario and date less the sales and cogs of the starting given scenario.
It looks like you added up all of the 2018 data and compared it to all of the 2017 data. I am asking how I can compare 2018 Actual Version to the 2018 Budget Version.
Hi ggipson,
Based on my test, you could refer to below steps:
Sample data:
Create a Waterfall Chart and filter out the data in 2017. Now you could see the result.
You can also download the PBIX file to have a view.
https://www.dropbox.com/s/0y6j47zh0c5gcll/Waterfall%20Chart%20Help.pbix?dl=0
Regards,
Daniel He
