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

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.