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.

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

Hi Krishna09 ,

 

The only thing I can think of to highlight rows in a table is through conditional formatting? Depending on the number of unique items in a column you have, it will be a tedious job as you also need to apply each conditional format to every column/measure in your table visual.

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

danextianThank you very much for quick response.

this data is updated every day, every time it upddats, it may have new ids and there are more than 1000 unique ids. How is it possible to do conditional formating?