Forum Discussion
Waterfall Challenge
Thank you dear for answer johnbasha33
I tried clicking on the Budget bar and right-clicking, but there is no option to set it as Total. See the attached.
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.