Matrix table layout settings

[一棵黄葛树]

Hello everyone, we recently encountered a case where the row fields of a matrix table have 3 layers. The client requested that the default layout be fully unfolded, meaning that all 3 layers are visible. But once the slicer is selected, it will automatically shrink to the first layer, and the other two layers will be folded and need to be deepened again.
Although tables can be implemented, column fields need to be written with measurement values one by one.
Is there any way to achieve the effect of deepening the row fields of a control matrix table to the bottom at all times when there are multiple layers?

[Ritaf1983]

Hi @一棵黄葛树 
Can you show the desired result?

[一棵黄葛树]

The final result is that no matter what filtering is done by the slicer, the matrix table always displays three layers like a table, not just the first layer, and the other two layers are folded, so there is no need to deepen the other two layers.

ths!

[Ritaf1983]

This is how it works as a default...

If my answer was helpful please give me a Kudos and accept as a Solution.

[一棵黄葛树]

The customer's requirement is that regardless of how the product slicer filters, the default way is to display both the supervisor and employee. Currently, only the lower layers of Bob are being viewed, and Cathy/Dave/Alice have not been unfolded (they should be unfolded like Bob).
thank you!

[Ritaf1983 · Accepted solution]

@一棵黄葛树 
It keeps the drill level that was before the slicing

the pbix is attached you can check
If my answer was helpful please give me a Kudos and accept as a Solution.

[一棵黄葛树]

I'm very sorry, I missed an important message:
The column field of a matrix table is a column composed of field parameters, which are divided into three categories, each with two measurement values. The slicer is also a column of this field parameter (i.e. three optional items). Whenever an optional item is filtered, it is actually filtering two fields of the matrix table, which is folded and not in an expanded state. It is hoped that it will be in an expanded state no matter what.

ths.!