Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

TOTALS in MATRIX per YEAR

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!

 

2 Replies

  • 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's avatar
      Anonymous
      Not applicable

      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.