Levels in drill down

[Antmkjr]

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

[v-henryk-mstf]

Hi @Antmkjr ,

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.

[Antmkjr]

Manually hide you mean?

[v-henryk-mstf]

Hi @Antmkjr ,

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.

[Antmkjr]

No other way?>

[v-henryk-mstf]

Hi @Antmkjr ,

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.

[Antmkjr · Accepted solution]

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

[mahoneypat]

You should be able to deselect Blank in the Level 3 and 4 Visual Level Filters for that matrix in the Filters Panel.

Pat

[Antmkjr]

When i deselect blank the entire category disappears, please find the attached sample file for ref.