expand collapse for column matrix

[nagaraj]

Hi,

 We have a requirement to display the matrix with Column headers ( has drilldown Year -- Quarter -- Month).

 I am not seeing + / - buttons for column headers. 

 Is it possible ?

[V-lianl-msft]

Hi @nagaraj ,

I don't think so. 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.

Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[nagaraj]

You mean, that we can't achieve this functionality of Expand / Collapse using Matrix for Column headers ?

OR

If there is a hierarchy created for Columns, then we can use + / - for expand and collapse ?

[mihart · Accepted solution]

Hi @nagaraj 

Yes, you need a hierarchy to exist in the data to be able to expand/collapse in the way you want. 

HTH

Michele

[V-lianl-msft]

Hi @nagaraj ,

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

Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[az38]

Hi @nagaraj 

not sure I understand completely what do you mean, but I know the only +/- option in built-in matrix visual that expands rows

[nagaraj]

I need to provide user an option to expand and collapse for columns.

So searching +/- buttons as we have the option for Row Headers