Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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.
Hi @mgibson44,
Have you turned on the subtotals for column subtotals under Format for Matrix?
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
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
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
65 |
User | Count |
---|---|
135 | |
117 | |
101 | |
71 | |
61 |