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
