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

Sharksguts's avatar
Sharksguts
Frequent Visitor
7 years ago

OK, I see my problem I haven't explained myself properly. I had created a matrix with multiple columns like below.

If you turn subtotal on it puts a total for each column and the grand total. Any way to just show the grand total?

 

 

 

The other problem I have is with my actual data, I get the following message which is why I had the sub total but no grand total.
What are my options for handling this?

 

 

Apologies for the poor explanation.

 

Regards


Richard

themistoklis's avatar
themistoklis
Community Champion
7 years ago

 

Untick row or column subtotals

  • Sharksguts's avatar
    Sharksguts
    Frequent Visitor
    7 years ago

    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.

     

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

      • Jrussi1301's avatar
        Jrussi1301
        Frequent Visitor
        3 years ago

        Thank you! That is exactly what I was looking for.

    • themistoklis's avatar
      themistoklis
      Community Champion
      7 years ago

      Sharksguts

       

      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

      • Sharksguts's avatar
        Sharksguts
        Frequent Visitor
        7 years ago

        So should I be using something else instead of a Matrix if I want to display some data in a table with grand totals?