Forum Discussion

chakarti's avatar
chakarti
Frequent Visitor
6 years ago
Solved

Waterfall chart PVM

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

 

 
Need Help
Tips and Tricks
  • MFelix's avatar
    MFelix
    6 years ago

    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.

1 Reply

  • MFelix's avatar
    MFelix
    Super User
    6 years ago

    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.