Forum Discussion
Waterfall Chart With Variances Across Multiple Years
Thanks for update, dbattin4 , native Waterfall chart in Power BI doesn’t show absolute values for each step unless it’s a “Total” column - it’s designed to show changes from one category to the next.
If your goal is a Waterfall per year showing Volume, Price, Frequency as steps,
the easiest fix is to add a slicer for year so only one year is visible at a time in the waterfall.Otherwise, the visual will always try to chain them together and you’ll get exactly the “movement” effect you’re seeing.
check and let me know if still issue persist, please share with some sample data. will check it.
Super UserHi dbattin4 - Visual is grouping them incorrectly before plotting.it can be fix for each variance measure only return a value for its specific category, and BLANK() for everything else. Right now your variance measures like Price Variance don’t have that filter dependency. check the below measure suggested by wardy912 . Since each variance measure now self-filters to its category, Power BI won’t sum unrelated categories together for the same year.
Hope the above suggesion helps. please check and let us know