Show Total in Stacked Column Chart with legend

[ADC]

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 total (A + B + C) for each month (on top of each column).

Is this possible?

[SonjaBerrios]

If you use a line and stacked column chart visual, then you can make the line be the total amount.  Go to the formatting section for the visual and expand the Shapes section, then change the Stroke width to 0 so the line won't show.  Next go to the Data labels section and turn on Customize series.  Then you can change the color and font size of the total value so it is different than the other data labels.

[SonjaBerrios]

If 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

[v-yuezhe-msft]

@ADC,

You can create a measure as follows to calculate the total docs number for each month.
total = CALCULATE(SUM(Table[docs number]),ALLSELECTED(Table[Month]))

However, in stacked column chart, when you drag field to Legend, it is not possible to drag more than one fields to Values. You can switch to use Line and stacked column chart and create the chart as shown in the following screenshot.



Regards,
Lydia

[ADC]

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

[v-yuezhe-msft · Accepted solution]

@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

[jdp215]

@v-yuezhe-msft 

This works if you only have a few values, but if you have hundreds of values this becomes tedious

[Anonymous]

Filters are not working for indvidual category it select whole x axis as filter.

[Anonymous]

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.