Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Levels in drill down

  I have a matrix with drill down option, for some categories there are 4 levels in the drill down where as for some others only 2 levels. For the ones with only 2 levels , for eg in this cas...
Need Help
  • Anonymous's avatar
    Anonymous
    5 years ago

    Hide Blank Level 3 & 4 = SWITCH ( TRUE (), ISINSCOPE ( Mapping[Sub Classification (Malls) 1] ) && ISBLANK ( SELECTEDVALUE ( Mapping[Sub Classification (Malls) 1] ) ), BLANK (), ISINSCOPE ( Mapping[Sub Classification 2] ) && ISBLANK ( SELECTEDVALUE ( Mapping[Sub Classification 2] ) ), BLANK (), SUM ( 'Table'[Column1] ) )

v-henryk-mstf's avatar
v-henryk-mstf
Icon for Community Support rankCommunity Support
5 years ago

Hi Anonymous ,

 

According to your description, it is temporarily impossible to directly delete the blank lines on the third and fourth levels. If you delete empty rows through the "filter" function, the entire matrix visual will be affected.

 

I think the best way is to use the "+ -" button to not expand the rows that do not meet the conditions. The reference is as follows:

 

Hope to help you solve the problem.


Best Regards,
Henry


If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Manually hide you mean?

  • v-henryk-mstf's avatar
    v-henryk-mstf
    Icon for Community Support rankCommunity Support
    5 years ago

    Hi Anonymous ,

     

    Yes, manually hide.


    Best Regards,
    Henry


    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

    • Anonymous's avatar
      Anonymous
      Not applicable
      5 years ago

      No other way?>

      • v-henryk-mstf's avatar
        v-henryk-mstf
        Icon for Community Support rankCommunity Support
        5 years ago

        Hi Anonymous ,

         

        So far this is the best solution. If you have other ideas. You can post your idea here: Ideas - Microsoft Power BI Community

        If there are a lot of votes, Microsoft will officially add this feature in the next update, hope it will help you.


        Best Regards,
        Henry


        If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.