Show average value in stacked bar chart for multiple months selected in slicer

[Anonymous]

Hello,

I have a table which contains certain values per month. I've created a stacked bar chart to show these values and a slicer with the month names so I can select the month and see the corresponding value for that specific month. If I select more than one month, though, the chart shows the sum for the months selected. I want it to show the average instead: if I select January, February and March, for example, I want the chart to show the average of the values for the quarter, and not the sum of them. How is it possible to achieve this result? Thanks in advance.

[v-xiaotang · Accepted solution]

Hi @Anonymous 

The easiest way is to change the setting to Average

Also, you can create a measure to calculate average of selected values. 

For example, you can use function AVERAGE()

Measure = AVERAGE('Table'[value])

or calculate the count of selected months, then calculate the total of related values, finally use divide(total,count).

Best Regards,

Community Support Team _Tang

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