The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends September 15. Request your voucher.
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.
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.
Proud to be a Super User!