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

Be one of the first to start using Fabric Databases. View on-demand sessions with database experts and the Microsoft product team to learn just how easy it is to get started. Watch now

Reply
mgibson44
Frequent Visitor

Need Cumulative Total On Matrix Chart

sample.png

 

In PowerBI I have a Matrix table that looks similar to this. It shows the totals under the month, but I can't figure out how to get it to show the total for January+February+March in the Total columun to the right. I used quick measure to get the monthly totals. Thanks for the help. 

3 REPLIES 3
v-piga-msft
Resident Rockstar
Resident Rockstar

Hi @mgibson44,

 

Have you turned on the subtotals for column subtotals under Format for Matrix?

 

column subtotals.PNG

 

If you still need help, please share the dummy pbix file which can reproduce the scenario, so that we can help further investigate on it? You can upload it to OneDrive or Dropbox and post the link here. Do mask sensitive data before uploading.)

 

Best  Regards,

Cherry

Community Support Team _ Cherry Gao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Thank you for your help. The column subtotals are turned on yet the totals column is still empty. 

Hi @mgibson44,

 

That's really strange.

 

If it is convenient, coud you share a dummy pbix file which can reproduce the issue, so that we can help further investigate on it? You can upload it to OneDrive or Dropbox and post the link here. Do mask sensitive data before uploading.)

 

Best Regards,

Cherry

Community Support Team _ Cherry Gao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

ArunFabCon

Microsoft Fabric Community Conference 2025

Arun Ulag shares exciting details about the Microsoft Fabric Conference 2025, which will be held in Las Vegas, NV.

December 2024

A Year in Review - December 2024

Find out what content was popular in the Fabric community during 2024.