Forum Discussion
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?
一棵黄葛树
It keeps the drill level that was before the slicingthe pbix is attached you can check
If my answer was helpful please give me a Kudos and accept as a Solution.
6 Replies
- 一棵黄葛树Helper II
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!
- Ritaf1983Super User
This is how it works as a default...
If my answer was helpful please give me a Kudos and accept as a Solution.