Total Labels Not Showing Average

[Nexter]

I have a number which is an average, and the totals are correctly shown in a table, but not when showing it in a bar visual and turning on total labels. With the total labels, it refuses to take the average and instead sums it.

In the attached picture you can see the table is showing 6.7% and 6.5% and is then showing the correct average of 3.0% (the denominator increases a lot when adding these together), however the total label in the visual shows a total of 13.1% (which is the sum of the two percentages).

Anyone have any ideas on how to get the total to reflect the true average? Thanks!

[v-chenwuz-msft]

Hi @Nexter ,

You can't configure total value in stacked bar chart, you can submit your ideas on Power BI ideas.

Or you can turn off the total values and create a measure for tooltips of this visual.

Measure = calculate(average('table'[values]),allselected(table[month]))

The results can be shown when the user hovers the mouse over them.

Best Regards

Community Support Team _ chenwu zhu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak]

@Nexter , if you are using total feature of stacked bar visual, That will be sum

Create stacked line visual, Switch off secondary y-axis. Show label for line and Under shape reduce line width to 0