Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
Krishna09
Helper III
Helper III

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 group or highlet with a color as shown below.

Please help me to solve and suggest possibilities.

Thank you for your time. 

 

 

Krishna09_0-1700337477933.png

 

4 REPLIES 4
Ritaf1983
Super User
Super User

Hi @Krishna09 

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

Ritaf1983_0-1700365565269.png

Pbix is attached

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

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?

danextian
Super User
Super User

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.










Did I answer your question? Mark my post as a solution!


Proud to be a Super User!









"Tell me and I’ll forget; show me and I may remember; involve me and I’ll understand."
Need Power BI consultation, get in touch with me on LinkedIn or hire me on UpWork.
Learn with me on YouTube @DAXJutsu or follow my page on Facebook @DAXJutsuPBI.

@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?

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

July Newsletter

Fabric Community Update - July 2024

Find out what's new and trending in the Fabric Community.