Hide duplicate intermediate level in Matrix

[Anonymous]

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?

[mussaenda]

You can do a condition like if Column b = Column c, then blank, else column c.

Then hide blanks on your matrix

[Anonymous]

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.

[v-yiruan-msft]

Hi @Anonymous ,

According to the method provided by @mussaenda , you can create calculate column like this:

projectN = if( 'Department'[Category]='Department'[Project], BLANK(),'Department'[Project])

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

[Anonymous]

Hi @v-yiruan-msft 
I need to completely hide the blank level, because the blank doesn't look good in the matrix.

[v-yiruan-msft]

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

[rajulshah]

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.