I'm building a waterfall chart using the simple waterfall visual and am receiving a request from stakeholders to show two individual values as 0 in the display but also contribute to the total value. is this possible in PowerBI? The stakeholders are firmly committed to this request but as far as I can see this is not possible.
In the screenshot below, they want the two circled values to always show as "0", with now fille, but the total value in blue to remain at the 142.57 number. Is this at all possible using dax in the measures for the visual or through formatting?
Hi @mwmchugh215
Unfortunately, unlike tables, this graph's total bar is generated from values of other bars and not our formula.
So we can't manipulate it with Dax, The result is that we can change the values of categories, but it will always change the total bar as well:
If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly
Hi @mwmchugh215
Unfortunately, unlike tables, this graph's total bar is generated from values of other bars and not our formula.
So we can't manipulate it with Dax, The result is that we can change the values of categories, but it will always change the total bar as well:
If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly
Helpful resources
Power BI Monthly Update - September 2025
Check out the September 2025 Power BI update to learn about new features.
FabCon Atlanta 2026
Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
