Forum Discussion
Hide duplicate intermediate level in Matrix
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?
7 Replies
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.
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:
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
Hi there !
Did you find any solutions?
Best regards,
Nekauli
