Forum Discussion
Default Matrix Visualization to Expanded, and disable collapsing?
Hi Paul,
The alternative way would be creating a new column to combine 'Employee ID' and 'Employee Name' in 'Employees' table with below DAX,
ID Employee Name =Employees[Employee ID] & " - " & Employees[Employee Name]Then keep the stepped layout enabled, but use this new column instead on your Matrix
Hi MasonMA -
Thank you for your reply. Ideally, I would like users to have the ability to expand and collapse at the top (company) level, so that they can achieve any of the following views (A, B, C):
What I'd like to do is avoid the possibility of a view like (D) below, where an Employee ID is displayed but the Employee Name is not :
... The option you suggested to turn off the +/- icons seems to apply to all grouping levels. Ideally, I would like the +/- icons to be available at the top level (Company) but not at the second level (Employee ID).
If this isn't possible, I am open to suggestions if there is an alternate way to accomplish the same objective.
I appreciate your help.
Best regards,
Paul
Hi Paul,
The alternative way would be creating a new column to combine 'Employee ID' and 'Employee Name' in 'Employees' table with below DAX,
Then keep the stepped layout enabled, but use this new column instead on your Matrix