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.
Hi,
I have a matrix made from data like in the following image.
There are 5 levels in the matrix, and there are cases when Project and Category have the same value. In the example below, there is one case where Category and Project both have the value 'Mobile'. The issue is that 'Mobile' appears twice in the matrix, and I need to show 'Mobile' only once, and the user has to still be able to drill down and see the values for levels Tasklist and Employee.
How can I do this?
You can do a condition like if Column b = Column c, then blank, else column c.
Then hide blanks on your matrix
Hi @mussaenda ,
Thanks for your reply.
If I do that, then everything under the level "Mobile" is hidden. I need to still show the levels "Tasklist" and "Employee" that are under Mobile.
Hi @Anonymous ,
According to the method provided by @mussaenda , you can create calculate column like this:
If use the above calculated column, the levels "Tasklist" and "Employee" still display, but the problem is the "duplicated" data of project may not be displayed when you drill down into project level (see below image ) . Then you can't know the values for which project... I haven't found another suitable way to display it . Anyway, I will try again later if there is any other way to achieve this .
Best Regards
Rena
Hi @Anonymous
I need to completely hide the blank level, because the blank doesn't look good in the matrix.
Hi @Anonymous ,
I'm sorry I haven't found the method to acheive your requirement. You can raise one idea ticket on Power BI Ideas by this link, you can vote it up and add your comments there to improve Power BI on this feature.
Best Regards
Rena
Hello @Anonymous,
I don't think so you can hide the row where the duplicate rows appear. There has to be some value for that particular column.
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 |
---|---|
76 | |
69 | |
54 | |
37 | |
35 |
User | Count |
---|---|
86 | |
68 | |
59 | |
51 | |
46 |