Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Column Total Labels

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?

 

Need Help
Tips and Tricks

1 Reply

  • v-zhangti's avatar
    v-zhangti
    Community Support
    3 years ago

    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.