Forum Discussion
dbattin4
1 year agoFrequent Visitor
Waterfall Chart With Variances Across Multiple Years
I have the following data with the variances created by measures. I want to show the vaiances in a waterfall table but when I do this the variances across the two years are being added together. I am...
- 1 year ago
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.
dbattin4
1 year agoFrequent Visitor
In the end I created measures for prior year sales and current year sales and turned off the total
rajendraongole1
Super User
1 year agoCool!