Forum Discussion

Sharksguts's avatar
Sharksguts
Frequent Visitor
7 years ago
Solved

Matrix Column Grand Total

I have searched the forumn but can't find the answer. I am using a matrix to get the table I am after, however cannot get it to show the Grand Total Column at the end. Should I be using a Matrix and ...
Need Help
  • v-lili6-msft's avatar
    v-lili6-msft
    7 years ago

    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

sunnsonofindia's avatar
sunnsonofindia
Advocate II
3 years ago

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.

sailochanar's avatar
sailochanar
Helper II
2 years ago

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 .

  • sunnsonofindia's avatar
    sunnsonofindia
    Advocate II
    2 years ago

    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).

    • sailochanar's avatar
      sailochanar
      Helper II
      2 years ago

      nope If I turnoff row subtotals the grand total values are not displayed .

      this way the data is displayed.

       

      • sunnsonofindia's avatar
        sunnsonofindia
        Advocate II
        2 years ago

        Turn on the Row Sub Total which appears in your screen shot, then expand this option by click at left arrow like icon, you will find row level option select 'Year' from the drop down, just below that you will see 'Show Subtotal' which will appear as 'on', turn that off and you will be able to see only grand total (which is actually a subtotal at 'Country' and the same you are leaving turned on).