Forum Discussion
Matrix Visual Total Row ONLY!
Hi,
I've been asking this for about eight years or so, but here it goes again:
How to display a Grand Total on a matrix without row subtotals?
The matrix contains 5 rows and 1 column. All measures in values. I don't want row subtotals.
Tried everything.
* Row subtotals on
* Per row level on for the 1st level (top) row
* Everything is drilled down to the lowest level.
* Layout is tabular
Thank you.
4 Replies
Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).
Do not include sensitive information. Do not include anything that is unrelated to the issue or question.
Need help uploading data? https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-p/963216
Please show the expected outcome based on the sample data you provided.
Want faster answers? https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523Thanks, but the model is so complex I can't even figure out how to give you sample data.
I thought I'd just have some toggle, like "Show Grand Total" on or off, but this is really complicated, so I'm just throwing the towel down and give up altogether.
I've now realized the Grand Total is there at the bottom.
However, because the rows contain thousands of items, one must scroll all the way down in order to see it. It isn't frozen like the table Grand Total.
This is so stupid I can't even believe it.
