Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

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...
Need Help
Anonymous's avatar
Anonymous
Not applicable
6 years ago

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.

Anonymous's avatar
Anonymous
Not applicable
6 years ago

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's avatar
    Anonymous
    Not applicable
    6 years ago

    Hi Anonymous 
    I need to completely hide the blank level, because the blank doesn't look good in the matrix.

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      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