Forum Discussion

uthall's avatar
uthall
Helper II
9 years ago
Solved

Grand Total Only

Hello,   I would like a matrix to show the grand total only, and not the subtotals..   There doesnt seem to be any option for this very basic requirement.   Am i missing something?
Need Help
  • tringuyenminh92's avatar
    tringuyenminh92
    9 years ago

    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.

androo's avatar
androo
Advocate III
4 years ago

I think this is so basic I must be missing something. But, this is trivial in an Excel standard or Power Pivot pivot, why is it so difficult or at least problematic in Power BI? Having this problem today, with row sub-totals on (which repeats every figure in my table) I have a grand total, but, turn row subtotals off, so that figures only display once and the grand total is turned off too. WTF. You can convert to a table but then you lose the grouing and expand collapse features of the PIVOT (sorry, Matrix). In general getting quick results is much faster inside Excel with power pivot, but, it seems Power BI is getting all the attention now.