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] ) )

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.

      • Anonymous's avatar
        Anonymous
        Not applicable
        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] ) )