Forum Discussion
Solved
Show Total in Stacked Column Chart with legend
Hi Community I have a stacked column chart showing the number of docs checked by month, separated in categories A, B and C. I get each individual value, but I also need the graphic to show the tota...
ADC,
Create another three measures in your table, and create Stacked Column chart as shown in the screenshot below.
A = CALCULATE(SUM(Table[docs number]),FILTER(Table,Table[Category]="A"))
B = CALCULATE(SUM(Table[docs number]),FILTER(Table,Table[Category]="B"))
C = CALCULATE(SUM(Table[docs number]),FILTER(Table,Table[Category]="C"))
Regards,
Lydia
SonjaBerrios
Advocate I
Advocate IIf you go to the formatting for the bar chart with a line, expand the Shapes section, and change the Stroke width to 0, then the line doesn't show