Matrix visualization change or add a column of averages

[Anonymous]

I have the following 5 metrics organized by date. Instead of a final column (or possibly adding a column to the right of it), I’d like a cumulative average of each metric across these months. But also need the average to adjust when I slice out to fewer months/weeks/etc. So it’d be a 5 cell column with the average for metric 1, then metric 2, etc. across the columns to the left. Thanks for any help!

[v-piga-msft]

Hi @Anonymous,

If it is convenient, could you share your desired output so that we could help further on it?

Best  Regards,

Cherry

[Anonymous]

I'm trying to remove the grand totals on the bottom and on the right. And add an average column on the right (so an average of each metric across time).

[Ashish_Mathur]

Hi,

So in the Total column, you want to see an Average.  Am i correct?  if Yes, then share the link from where i can download your PBI file.

[Anonymous]

Yes, that's correct.

https://we.tl/t-BOp6rbA7xc

[Ashish_Mathur]

Hi,

Sorry but i don't think that i undestand your question and your data very well.  Someone else will help you.