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 o...
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