cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Post Patron
Post Patron

how 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:

 

jitpbi_0-1611571479840.png

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

 

jitpbi_2-1611571819457.png

 

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

 

Thanks

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

View solution in original post

4 REPLIES 4
Super User III
Super User III

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

 

AllisonKennedy_0-1611573495803.png

 


Has this post solved your problem? Please mark it as a solution so that others can find it quickly and to let the community know your problem has been solved. 


If you found this post helpful, please give Kudos.


I work as a trainer and consultant for Microsoft 365, specialising in Power BI and Power Query. 


www.excelwithallison.com

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.

View solution in original post

Super User IV
Super User IV

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



Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
Dashboard of My Blogs !! YouTube Channel !! Connect on Linkedin

Proud to be a Super User!

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

 

Thanks

Helpful resources

Announcements
secondImage

Congratulations!

We are excited to announce the Power BI Super Users!

Wave Release 2

Check out the updates in Power BI.

Overview of Power BI 2020 release wave 2!

Microsoft Ignite

Microsoft Ignite

Join digitally, March 2–4, 2021 to explore new tech that's ready to implement. Experience the keynote in mixed reality through AltspaceVR!

secondImage

The largest Power BI virtual conference

100+ sessions, 100+ speakers, Product managers, MVPs, and experts. All about Power BI. Attend online or watch the recordings.

Top Solution Authors
Top Kudoed Authors