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 -Selected Measure is returning the correct variance values per year, but the Waterfall visual is aggregating them when the X-axis has more than one year in scope.
Selected Measure =
VAR _Year = MAX( Invoices[DocFinYear] )
RETURN
SWITCH(
TRUE(),
SELECTEDVALUE(SalesVarianceTable[Category]) = "Volume",
CALCULATE([Volume Variance Old], Invoices[DocFinYear] = _Year),
SELECTEDVALUE(SalesVarianceTable[Category]) = "Price",
CALCULATE([Price Variance], Invoices[DocFinYear] = _Year),
SELECTEDVALUE(SalesVarianceTable[Category]) = "Frequency",
CALCULATE([Frequency Variance], Invoices[DocFinYear] = _Year),
CALCULATE([Total Sales], Invoices[DocFinYear] = _Year)
)
try this and let know.
rajendraongole1 This still gives the same answer. I undestand your logic but I wonder if its the visual. The variances are correct it is just looking at the movement in the variances not the absolute value
- rajendraongole1
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.
In the end I created measures for prior year sales and current year sales and turned off the total
- rajendraongole1
Cool!