March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early bird discount ends December 31.
Register NowBe one of the first to start using Fabric Databases. View on-demand sessions with database experts and the Microsoft product team to learn just how easy it is to get started. Watch 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.