Forum Discussion

RT3308's avatar
RT3308
Helper I
6 years ago
Solved

Matrix Row Grouping OFF Column Grouping ON

Hello... please help (PowerBIDesktop & OnPremise PBIRS).

 

Is there a matrix where RowGrouping is OFF and ColumnGrouping is ON?  I don't need the Row fields to be grouping... but I need the Column field (e.g. Months) to be grouped.  Basically, I've got dimensions on Rows that I want to just repeat on each row and therefore treated as individual rows (combination of different fields).  I need them to be sorted by Columns-Values Totals... so having the Row Grouping will prohibit it from sorting the way I want it to be. 

 

Thank you sooo much!

Need Help
  • parry2k's avatar
    parry2k
    6 years ago

    RT3308 unfortunaltey you cannot achieve this to repeat the value on each row for main group. May be you want to add this on ideas forum or vote if Idea already exists.

5 Replies

  • parry2k's avatar
    parry2k
    Super User
    6 years ago

    RT3308 not sure what you mean row grouping off,  you don't want to show row group total , is that what you are asking for? Please provide more context.

    • RT3308's avatar
      RT3308
      Helper I
      6 years ago

      Hello parry2k , thanks for the reply.

      I can turn off the group subtotals - but it's not what I need. 

       

      Matrix Rows Fields: Region, Class, Description

      Matrix Column Fields: Month-Year

      Matrix Values: Sum of Score

       

      Basically I need this

       

      to turn into this

      • parry2k's avatar
        parry2k
        Super User
        6 years ago

        RT3308 unfortunaltey you cannot achieve this to repeat the value on each row for main group. May be you want to add this on ideas forum or vote if Idea already exists.