Waterfall chart PVM

[chakarti]

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

[MFelix · Accepted solution]

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.