Forum Discussion

Krishna09's avatar
Krishna09
Icon for Helper III rankHelper III
2 years ago
Solved

Group rows in table based on identical values in a column

Hello all,   In Power BI desktop, there is a table with ID and many other columns. I need help in making group. In table visual, is it possible to group same(identical) values in a cloumn to grou...
General Comment
Need Help
Tips and Tricks
Tutorial Requests
  • Ritaf1983's avatar
    Ritaf1983
    2 years ago

    Hi Krishna09 

    You can use a Matrix visual with a hierarchical form to group the values:

    Pbix is attached

    If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly.

Ritaf1983's avatar
Ritaf1983
Icon for Super User rankSuper User
2 years ago

Hi Krishna09 

You can use a Matrix visual with a hierarchical form to group the values:

Pbix is attached

If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly.

  • Krishna09's avatar
    Krishna09
    Icon for Helper III rankHelper III
    2 years ago

    Thank you very much for quick reply. I tried this, it works only for two columns. In this visual there are around 10 columns. so it does not work.

    If I use Matrix, these IDs are unique, but I want to show in multiple lines( if the table contains 2 similar id then two of them, if three similar id then three rows with this id information.). is it possible?