Total column in the column chart

koorosh So like a column that displays the sum of C, A and B or ?

koorosh 

While it's technically feasible to add a 'Total' value to the category values and adjust the DAX formula for conditional calculation, I would advise against it. The primary purpose of the chart is to compare distinct categories on a given scale. Introducing a 'Total' within the same chart might distort the visual representation and make it challenging to interpret individual category differences accurately.

Instead, I recommend visualizing the 'Total' as a separate chart adjacent to the main one. This way, viewers can easily distinguish between the comprehensive total and the individual category values, maintaining clarity and facilitating a more accurate comparison.

Separating the 'Total' chart also allows for a more focused analysis, as users can choose to assess either the overall picture or delve into specific category details based on their analytical needs