Forum Discussion
Dynamic Total Labels in Stacked Column Chart: Summing Percentages vs. Re-calculating YoY
Hello AlonCarmel,
This is by design in Power BI.
Stacked column charts always aggregate the values in the visual. Total labels do not evaluate a separate measure; they simply display that aggregation.
That’s why:
Value view works (values are additive)
YoY view does not (percentages are not additive)
So the total label is effectively summing the segment YoY values instead of recalculating YoY at the total level.
There is no way to change this behavior using DAX or formatting.
Official reference:
Visualizations overview in Power BI
Workarounds:
Use a line and stacked column chart (columns for segment YoY and a line for the correct total YoY)
Or turn off total labels and show the correct total separately (for example, with a card or tooltip)
Hello AlonCarmel,
This is by design in Power BI.
Stacked column charts always aggregate the values in the visual. Total labels do not evaluate a separate measure; they simply display that aggregation.
That’s why:
Value view works (values are additive)
YoY view does not (percentages are not additive)
So the total label is effectively summing the segment YoY values instead of recalculating YoY at the total level.
There is no way to change this behavior using DAX or formatting.
Official reference:
Visualizations overview in Power BI
Workarounds:
Use a line and stacked column chart (columns for segment YoY and a line for the correct total YoY)
Or turn off total labels and show the correct total separately (for example, with a card or tooltip)