Forum Discussion

vishnukumar's avatar
vishnukumar
Advocate I
8 years ago
Solved

Grouping table rows based on values

Hi,   I am new to PowerBI Desktop. I would like to group rows based on column values. Here I have given below example what I am trying to achieve. Can some one share me the step by step guiding doc...
  • vishnukumar's avatar
    vishnukumar
    8 years ago

    Hi,

     

    My problem resolved by using matrix and below tips.

     

    "Once you have your values set in the row section of your matrix, go to your visualization. In the upper left, click the drilldown "Expand all down one level in the hierarchy" it is the right-side selection that forks. Click that until you get to the bottom level of what you want to see. Then go to the formatting option for the matrix, under "Row Headers" turn "Stepped layout" off.

     

    That should list your matrix in a table style look while not repeating the valuse of the left side columns. "

     

    Regards,

    Vishnu