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 September 15. Request your voucher.

Reply
Lolwife1966
Frequent Visitor

Waterfall Chart with starting value

I have a query which contains data for a number of companies (for argument's sake let's call them CompanyA to CompanyG). The query contains a separate record for each comapny for each week.
Two of the columns that are stored against each record are Budget and BudgetVariance.
I am required to create a waterfall chart for each week that has the sum of budget for all companies as a starting value then displays the variance for each company with the total variance as the final column (hope this makes sense).
I can show the variance on the Y-axis, my issue is how can I display the total budget as the starting value, I can't see any way to add a starting value to the waterfall chart.

1 REPLY 1
KerKol
Power Participant
Power Participant

I'm trying to understand your requirements...

What I've done in the past to make custom waterfalls is create calculated tables, so that the sum of budget shows first on the X-Axis, then followed by each of the company names with sum of budget variance, then a grand total.

I often used a stacked bar chart.





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




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.

Top Kudoed Authors