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, would this be the view you were looking to have? If it is you can disable the '+/- icon' for stepped layout under Text, Row headers.
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,
ID Employee Name =Employees[Employee ID] & " - " & Employees[Employee Name]Then keep the stepped layout enabled, but use this new column instead on your Matrix