Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

Grouping in Matrix

Hi all, Good Day. I have no idea how to generate a matrix view with Grouped items on the Row well. Please check the attached screenshot and it shows the way I wanted to group the items. Please help ...
Need Help
Show and Tell
  • v-juanli-msft's avatar
    v-juanli-msft
    8 years ago

    Hi Anonymous

    First make sure your dataset structure like below

    Then add "parent" and "child" column to the Row field of a Matrix visual, then click on the fourth icon to let the row show at the lowest level.

     

    Additional you could select Rows Headers->Stepped layout, turn off this option, you could see the picture as below.

     

    If you have any question, please feel free to ask me.

     

    Best Regards

    Maggie

     

v-juanli-msft's avatar
v-juanli-msft
Community Support
8 years ago

Hi Anonymous

First make sure your dataset structure like below

Then add "parent" and "child" column to the Row field of a Matrix visual, then click on the fourth icon to let the row show at the lowest level.

 

Additional you could select Rows Headers->Stepped layout, turn off this option, you could see the picture as below.

 

If you have any question, please feel free to ask me.

 

Best Regards

Maggie

 

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Hi ,
Grouping works perfectly fine, but I wanted to sort the "parent" column in a particular order. So, I created supporting table with ranking and pulled the respective column from the newly created table into the matrix. Now smth went wrong and grouping does not work any more. I cant figure out why.. puzzled. If any one could help!