TOTALS in MATRIX per YEAR

[Anonymous]

Hello guys, 

I have the following visualization that I created with Power BI and a matrix:

I achieved this by setting the following parameters:

• In rows:

• In columns:

• In values:

However, I need the totals of each of the columns by year, something like what I have in the following image, but in a single matrix:

My goal is to get something like this (the blue one):

Any idea how it could be built?

Don't worry about the data, it's infinite or something like that, because it's Data Dummy

Cheers!

[Chew_WenJie]

Hello, under the matrix visualization formatting have a Column subtotals, turn it on, it should be output the total you wanted.

Hope this able to solve your problem.

[Anonymous]

No, that is not what I need because it only gives you the total general:

I need the total per year, in this case, the total for 2021 and then the total per 2022.