Forum Discussion
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 case Write Off , i dont want blank to be displayed in 3rd and 4th level, how to do this?
Sample file attached:
https://drive.google.com/file/d/1GxPiajMP6seQSnRFa7eLVlJdm9Hvri8w/view?usp=sharing
Dont want these blank rows to appear
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] ) )
8 Replies
- mahoneypat
Microsoft Employee
You should be able to deselect Blank in the Level 3 and 4 Visual Level Filters for that matrix in the Filters Panel.
Pat 
v-henryk-mstfCommunity Support
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.- v-henryk-mstf
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.
