Displaying Multiple Totals Power BI Matrix with Selected Value

[atari35]

Hi,

I'm having an issue with creating a Matrix Visual that will return custom totals at the end of the table. What I have is rows Categories and Columns have Calendar dates and i want to display Totals, Averages and Variances after the calendar date, which is dynamic based on a slicer, what this means is I will have a slicer to select a month and the Matrix visual will return the last 6 months including the current selected month and also do those calculations like Total, Average , Month on Month Variance and a % Change

Below example i selected the month of June 2023 from my slicer

[lbendlin]

You can have custom totals, but only as many as you have column fields. In your case you have one field (date) so you get one total.

[atari35 · Accepted solution]

Thank you however i got my answer from this youtube video. Very informative, 

Maximizing Power BI Matrix Visual: Displaying Multiple Totals for Better Insights