HI Guys
i am relatively new with the Power BI but have a mid level of experience with POwer query which helps me to advance quite fast. Also with DAX 🙂
i have the following issue with a waterfall bridge on Net Sales Variance - study period vs referance period
i start with the referance period(5553), then power bi adds up the volume(+901) ,mix(+223) & price(-5) effects properly and the study period(which is result of the other figures = 6671) stays in the "sky" and is not build up from the axis like the referance period bar. What setting am i missing ?
i am using power BI desktop version
Hi @chakarti ,
In the waterfall charts the end value is a cumulative value of the previous values, based on the data you show in the print you have NS Feb 20 as a data point on yor data so you simply need to filter out that category from your waterfall chart and you will get the desired result.
Regards
Miguel Félix
Did I answer your question? Mark my post as a solution!
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsHi @chakarti ,
In the waterfall charts the end value is a cumulative value of the previous values, based on the data you show in the print you have NS Feb 20 as a data point on yor data so you simply need to filter out that category from your waterfall chart and you will get the desired result.
Regards
Miguel Félix
Did I answer your question? Mark my post as a solution!
Proud to be a Super User!
Check out my blog: Power BI em Português
Helpful resources
Power BI Dataviz World Championships
The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!
Power BI Monthly Update - November 2025
Check out the November 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.
