Forum Discussion
Waterfall Challenge
Hi Power BI experts, I have data like this: index cat value 1 Budget NPAT 4,261,532 2 Gross Margin 2,733,696 3 Variable Costs -280,573 4 3rd Party Cost Recovery -435,951 ...
Hi majid154a
Short answer:
You’re using “Sum of value” (implicit aggregation) → that’s why Set as total is missing.
Fix (2 steps):
1️⃣ Create an explicit measure
Amount := SUM ( 'Table'[value] )
2️⃣ Use Amount in the Waterfall (not Sum of value)
➡️ Now right-click Budget bar → “Set as total” will appear.
Why:
Power BI only enables Set as total when the Y-axis uses a measure, not an auto-aggregated column.
That’s it.
Did I answer your question? Mark my post as a solution! Appreciate your Kudos !!
Dear johnbasha33 Thank you for the secnoed help.
I used measure as you suggested instead of the aggregate column, but the set as total still does not appear. Please see the attached
Can you do in your PBI and share it if its work.