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

how do you write a measure for  custom values for child in  this structural grouping?

  • jprdynamicapps's avatar
    jprdynamicapps
    Helper IV
    6 years ago

    The grouping has no effect on the rows, and you can consider that a measure will be calculated as if all columns were populated in a table.  If you're looking to do a different calculation depending on hierarchy level, you'll want to use a switch based on ISINSCOPE.