Expand/Collapse Matrix Columns

[Anonymous]

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

[Anonymous · Accepted solution]

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.

https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/36038050-add-expand-collapse-feat... 

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]

How can I enable drill-down on the columns? I don't see that option anywhere

[Anonymous]

@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.