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 me how to do it in Power BI Desktop. 

Note: I tried to use the "New Group option" and grouped some of the items. But, when I used that into my matrix table, it didn't showed me with the expanded group view, I mean the child items associated to a parent were not displayed. All I got was only the Parent items on the Matrix Row well. Any help will be much appreciated. 

 

Thanks,

Praveen. 

 

 

 

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

     

7 Replies

  • 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
      8 years ago

      Thank you very much Maggie for your kind reply to my question. Keep answering to all of our questions. 

       

      God bless you and family,

      Praveen. 

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

    • 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!