Column Total Labels

[Anonymous]

I have a stacked column chart with 3 separate values. Am I able to set the total label to show the sum of only two of the values shown?

In this example I want the total labels to display 171m and 172m as opposed to the total aggregates of 212 and 213m for all three values. Is this possible?

[v-zhangti]

Hi, @Anonymous 

Sample data:

After testing, it was not possible to write measure to change the total value in total labels.

But you can try putting measure in a tooltip.

Measure = CALCULATE(SUM('Table'[Value]),FILTER(ALLEXCEPT('Table','Table'[Type]),[Item]<>"C"))

Hope that can help you.

Best Regards,

Community Support Team _Charlotte

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.