Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

No columns subtotal in Matrix

Hi everyone.

I am a new Power BI user and appreciate if you help me out here.

I created a matrix, but I cant see the columns subtotal . I have rows subtotal , but columns ! I checked the format for the matrix, but there is not any option for columns subtotal. 

  • Anonymous's avatar
    Anonymous
    8 years ago

    I end up adding a calculated column for subtotal .

4 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    Anonymous,

    What version of Power BI Desktop do you use? Could you please share sample data of your original table? In my scenario, I can turn on column subtotals under Format->Subtotals.



    Regards,
    Lydia

    • RuudPolly's avatar
      RuudPolly
      New Member
      8 years ago

      I have the same issue. There is no slider for column subtotal.

      I use the june 2018 version of PowerBI desktop. Bacuase of a bug in the july and august version I cannot install a newer version of PowerBI.

      • Anonymous's avatar
        Anonymous
        Not applicable
        8 years ago

        I end up adding a calculated column for subtotal .

    • Anonymous's avatar
      Anonymous
      Not applicable
      5 years ago

      what version of bi desktop are you using? I'm currently on the Oct 2020 Power Bi desktop and this feature is not available.