Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
ggipson
Frequent Visitor

Waterfall Chart Help

 

I am new to this visual and am having issues getting it to show anything that I want besides a CY to PY bridge. I have attached a sample of what my data looks like and a couple examples of what waterfalls I would need. 

 

Any help with the basics is welcome. I specifically cannot seem to get to the CY vs Budget view attached. CY v PY.JPGCY v Budge.JPG

 

DateVersionAccountAmount
1/1/2017ActualCOGS-75
1/1/2017ActualSales90
1/1/2018ActualCOGS-82
1/1/2018ActualSales100
1/1/2018BudgetCOGS-79
1/1/2018BudgetSales95
1/1/2018ForecastCOGS-80
1/1/2018ForecastSales97
1 ACCEPTED SOLUTION

Hi @ggipson,

Based on my test, you could refer to below steps:

Sample data:

1.PNG

Create a Waterfall Chart and filter out the data in 2017. Now you could see the result.

2.PNG

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

Community Support Team _ Daniel He
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

3 REPLIES 3
v-danhe-msft
Microsoft Employee
Microsoft Employee

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.

1.PNG

 

Regards,

Daniel He

Community Support Team _ Daniel He
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

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 = 16

 

The 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:

1.PNG

Create a Waterfall Chart and filter out the data in 2017. Now you could see the result.

2.PNG

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

Community Support Team _ Daniel He
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Announcements
August Power BI Update Carousel

Power BI Monthly Update - August 2025

Check out the August 2025 Power BI update to learn about new features.

August 2025 community update carousel

Fabric Community Update - August 2025

Find out what's new and trending in the Fabric community.