Forum Discussion
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
- Chew_WenJie
Resolver III
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.
- AnonymousNot 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.