Remove blank row level in Matrix visual and keep the data

Hi Jidapa18 ,
Thanks for sharing the comparison and screenshots.

What you’re seeing in the “Remove Blank Row Level” visual is expected. When a level is removed because it has no value, it is no longer part of the matrix. When you expand or drill, only the remaining visible levels are used, so some parent levels can be skipped even though the lowest level still shows a value.

In the “Not Remove Blank Row Level” case, all levels are kept, so the full expand path is shown. This isn’t caused by the measure, since the value is correct in both visuals. It’s a limitation of how the matrix works when parent levels are hidden.

If you need the expand or collapse behavior to stay consistent, the parent levels must remain visible. Once they are removed, they can’t be brought back during drill.

As an alternative, you can switch the matrix layout to Tabular. This shows each level in its own column and avoids expanding into empty leaves. It changes the layout and doesn’t keep the stepped drill behavior, but it can work depending on the requirement.

Hope this helps clarify the behavior and available options.