Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Get 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

Matrix Expand all levels by Default Option

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

Status: New
Comments
miquelmartorell
Advocate II

We definitely deserve this feature, come on Microsoft!!!

cheng_lelouch02
New Member

Microsoft team... we need this feature ASAP.. and it shouldn't be difficult at all. Add a toggle in the matrix settings where users can choose default mode to be collapse or expand-all

viraj_arsekar
Frequent Visitor

Same issue here. Using field parameters to dynamically switch the columns. Such a shame, this small thing makes the field parameter in this case scenario useless. Hopefully they'll provide a feature soon to allow expanded by default.