how to display column headers as row headers in Matrix visual

[jitpbi]

Hi,

I am working on matrix visual where showing 2 fields on rows and 2 fields on columns. On the row headers, both the fileds are visible when drilldown but when drilldown on cloumns it shows 1 field at a time. I need both the fields on column should be visible as like in the below matrix:

But on the matrix visual in PBI desktop, it shows only 1 field on cloumn like this:

Is there any possible way to represent the columns in PBI desktop Matrix visual as like the columns in the first image?

Thanks

[AllisonKennedy]

@jitpbi  Did you use the 'Expand all down one level in hierarchy' or 'go to next level in hierarchy'? It should work as you desire if you choose the 'Expand all down one level in hierarchy' option. If not, please explain further what you mean. 

[jitpbi · Accepted solution]

Yes @AllisonKennedy , now it is working fine when click on 'Expand all down one level in hierarchy'. it was not working earlier when i tried this. Also still doesn't show when click on 'go to next level in hierarchy' only shows when click on 'Expand all down one level in hierarchy'.

Thank you for the help.

[amitchandak]

@jitpbi , You also expand the columns using the expand icon, the square reverse Y icon. 

[jitpbi]

Thanks @amitchandak , I got it and its working for me.

Thanks