Forum Discussion
Grand Total Only
Yeah, Agree with Anonymous, uthall you should let matrix show details and turn off total row,column. and then show Grand total in Card next to matrix.
You can't selectively turn off subtotals in the matrix visual. You either get subtotals for everything, or no totals at all. Those are your only options. For some reason they left this basic feature out. The best workaround I've found is to write a measure that produces some of the items you would use for the non-subtotaling columns, and use that in the values.
Yeah, Agree with Anonymous, uthall you should let matrix show details and turn off total row,column. and then show Grand total in Card next to matrix.
To All,
I'm working with PBI version 2.119.986.0 64-bit.
Under "Row subtotals"
Select 'Per row level'
then select 1 by 1 for each field and under "Rows" turn 'Show subtotal' Off.
Leaving "Row subtotals" turned on.
Ok, not a bad workaround, but hard to position the card if the number of rows in the matrix is variable depending on filters.....
Hi :) how to show details as I cannot see this option my goal is to have grand total but not row totals
how to show detail I cannot fidn this option:( I also woudl liek to se teh grand total of a row but not see sub totals
