Starting December 3, join live sessions with database experts and the Microsoft product team to learn just how easy it is to get started
Learn moreGet certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now
When loading a new column to the matrix hierarchy, the defualt of the matrix is to be in collapse mode and then the user need to drill down in order to see the entire selection, and my suggestion/my need is to always be in expand all mode.
I know that if you save the report in drill down and then when you load it again the matrix will be expanded but a) that isn't a good solution overall b) it doesn't work in my situation where the matrix is dynamic and the user has a chance to remove and add layers to the hierarchy to his or hers choice with a switch/field parameter measure
so basically the idea is to have the matrix to be on expand all always
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.