Forum Discussion
Show Total in Stacked Column Chart with legend
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
Lydia,
Thanks a lot for your answer.
It is a nice workaround and I get the total sum shown in the graphic that way.
However, I was wandering if the total sum of the categories can be shown in each column, on top of the column.
I need that very frequently and the Line sometimes generates confusion on the audience.
Any other way to handle it?
Thanks again.
Regards.
Alejandro
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
Filters are not working for indvidual category it select whole x axis as filter.
we can use drill down feature of power bi to filter seleted pane so we can filter that selected pane data.
for filter purpose use category of the given pane in axis field.
Anonymous
This works if you only have a few values, but if you have hundreds of values this becomes tedious