Forum Discussion
Expand/Collapse Matrix Columns
Hello all,
I would like to know if it is possible to have certain columns in a matrix expand or collapse just like you can with the rows
Here is my example:
I would like for the end user to be able to expand/collapse on Acutal Overtime Premium and Budgeted Contract Salaries
Thanks
Hi Anonymous ,
The fields can be expanded only when there is a hierarchy in the data. The hierarchy between columns does not exist and only exists between rows.
But you can try to drill on the columns.
Hence, We can't achieve this functionality of Expand / Collapse using Matrix for Column headers for the time being.
You can vote for this idea and focus on what's going on.
Do not hesitate to give a kudo to useful posts and mark solutions as solution
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
3 Replies
Hi Anonymous ,
The fields can be expanded only when there is a hierarchy in the data. The hierarchy between columns does not exist and only exists between rows.
But you can try to drill on the columns.
Hence, We can't achieve this functionality of Expand / Collapse using Matrix for Column headers for the time being.
You can vote for this idea and focus on what's going on.
Do not hesitate to give a kudo to useful posts and mark solutions as solution
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Anonymous ,
Can you please share a sample pbix?
That drill down will again work for all the columns not for selective columns.
For that you would need to pass two attributes in the columns section of visualization pane.
Do not hesitate to give a kudo to useful posts and mark solutions as solution
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.