Forum Discussion
Matrix Column Grand Total
hi, Sharksguts
After my research, I'm afraid it couldn't achieve in Power BI for now.
But you may try this way, add a matrix or table visual with only column Part Number and Value, then they will be the Grand Total for
basic matrix column, and they can interact with each other.
For your requirement, you could post your new idea in Power BI ideas and make this feature coming sooner.
another question, for you want to show the values of every day for the column, this exceeds the maximum number of items that can be displayed for column, Not only does it not have grand total but also the sub total.
So you could these two ways:
1. move the column Values field into row and row Value field into column.
2. use a slicer to filter data to reduce the number of items of date.
Best Regards,
Lin
Untick row or column subtotals
I am trying to get it to just show the grand total if I switch off sub totals then I get no grand total column.
Hey I know it is very old but putting the response for others.
Go to Visual -> Row subtotals -> Turn on 'Per row level' option under 'Apply setting to' head, and choose the very first column of your visual, move to next head 'Rows' and turn on 'Show subtotal' option - put text for sub total label e.g. 'Total' or 'Grand Total'. Now chose next columns one by one under 'Apply settings to' option and this time turn off 'Show subtotal' option under 'Rows' head.
Thank you! That is exactly what I was looking for.
Hi Mate ,
I followed same as u said but still for each row the total value is shown which I don't want, only grand total value required ,how to acheive that .
Thanks in Advance .it seems row subtotal is turned on for 'Year', you need to turn that off. to do that follow the steps from my answer (earlier post).
This is the answer I needed. Just one more thing, when I export, it's telling me that it exceeded the allowed volume and hence, not showing the Totals. When I use less records it works just fine, however I think it's weird since I'm not exceeding the 150K record's limit (Barely 15K as shown on screenshot. Is there something I'm not seeing?
Probably your matrix has multi tier columns or multiple columns which increases the numer of intersections due to which even when you have less than 150K rows you are not able to export it completely because it is number of intersections not rows which caps the limit.
In such a situation I use PowerBi Paginated Report which let you subsribe/download the report in tabular format, in case you need in matrix format you may edit the paginated report in Power Bi Report Builder then publish it back.
Refer below solution for more detail
Solved: Re: Export Data to Excel - Export Data exceeded. - Microsoft Fabric Community
I think you cannot do this...
But the workaround will be to turn subtotals on and put font and background color the same as the color of the cell (this way it till be hidden).
Then change the font color of the grand total to a color different from the one in the cell
So should I be using something else instead of a Matrix if I want to display some data in a table with grand totals?
