Forum Discussion
Post Patronhow to display column headers as row headers in Matrix visual
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
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.
4 Replies
- amitchandak
Super User
jitpbi , You also expand the columns using the expand icon, the square reverse Y icon.
jitpbi
- AllisonKennedy
Community Champion
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
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.
