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
mwmchugh215
Frequent Visitor

Waterfall Chart

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?

 

mwmchugh215_0-1694201299976.png

 

 

1 ACCEPTED SOLUTION
Ritaf1983
Super User
Super User

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:

Ritaf1983_0-1694240298096.png

If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly

Regards,
Rita Fainshtein | Microsoft MVP
https://www.linkedin.com/in/rita-fainshtein/
Blog : https://www.madeiradata.com/profile/ritaf/profile

View solution in original post

1 REPLY 1
Ritaf1983
Super User
Super User

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:

Ritaf1983_0-1694240298096.png

If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly

Regards,
Rita Fainshtein | Microsoft MVP
https://www.linkedin.com/in/rita-fainshtein/
Blog : https://www.madeiradata.com/profile/ritaf/profile

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.