Power BI is turning 10, and we’re marking the occasion with a special community challenge. Use your creativity to tell a story, uncover trends, or highlight something unexpected.
Get startedJoin us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.
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.
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.
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?
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.
@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?
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
Check out the June 2025 Power BI update to learn about new features.
User | Count |
---|---|
72 | |
68 | |
53 | |
39 | |
33 |
User | Count |
---|---|
70 | |
63 | |
57 | |
49 | |
46 |