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 UserThanks 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.
In the end I created measures for prior year sales and current year sales and turned off the total
- rajendraongole1
Cool!