Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
RickSuAs
Regular Visitor

TOTALS in MATRIX per YEAR

Hello guys, 

 

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

 

RickSuAs_0-1663537503525.png

 

 

I achieved this by setting the following parameters:

 

  • In rows:

RickSuAs_1-1663537503421.png

 

 

  • In columns:

RickSuAs_2-1663537503728.png

 

 

  • In values:
 

RickSuAs_3-1663537503420.png

 

 

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:

 

RickSuAs_4-1663537503626.png

 

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

 

RickSuAs_5-1663537579473.png

 

 

 

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 2
Chew_WenJie
Resolver II
Resolver II

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

Chew_WenJie_0-1663546640193.png

 

Hope this able to solve your problem.

 

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

RickSuAs_0-1663597977312.png

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

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

Top Solution Authors