Forum Discussion
Matrix table layout settings
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!
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!一棵黄葛树
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.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.!