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

Matrix VisualFieldsFields details

Dear All,

I'm having two tables from which I have created the above Matrix visuals but the requirment is that the fields are not coming in +- (expand/shrink) at Row Level, also I have turned on Values"Show on Rows" . Please note my Values are in seperate measure so that can not be moved to Row level
Best Regards
Manik Nag