Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Get Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request now

Reply
admin11
Memorable Member
Memorable Member

Matrix Table how to make dimension display Company Name on 1st column and Term at 2nd column ?

Hi All

 

I have a AR report work fine last 2 year as below :-

admin11_0-1652611415020.png

Today i just try to create same matrix table like above , but the Term field not appear at 2nd column. see below image :-

admin11_1-1652611585022.png

 

Hope some one can advise me why ?

 

below is my PBI file :-

 

https://www.dropbox.com/s/6mtqlox1r3ch3sz/AR%20ADL%20V002.pbix?dl=0

 

Paul

1 ACCEPTED SOLUTION
tackytechtom
Super User
Super User

Hi @admin11 ,

 

I intepreted that you'd like to change the layout of the graph on the left to the layout of the right:

 

tomfox_0-1652615484315.png

 

If this is what you're after, then you can turn off stepped layout under Row headers:

tomfox_1-1652615578852.png

 

Let me know, if this helps 🙂

 

/Tom
https://www.tackytech.blog/
https://www.instagram.com/tackytechtom/

 



Did I answer your question➡️ Please, mark my post as a solution ✔️

Also happily accepting Kudos 🙂

Feel free to connect with me on LinkedIn! linkedIn

#proudtobeasuperuser 

View solution in original post

2 REPLIES 2
tackytechtom
Super User
Super User

Hi @admin11 ,

 

I intepreted that you'd like to change the layout of the graph on the left to the layout of the right:

 

tomfox_0-1652615484315.png

 

If this is what you're after, then you can turn off stepped layout under Row headers:

tomfox_1-1652615578852.png

 

Let me know, if this helps 🙂

 

/Tom
https://www.tackytech.blog/
https://www.instagram.com/tackytechtom/

 



Did I answer your question➡️ Please, mark my post as a solution ✔️

Also happily accepting Kudos 🙂

Feel free to connect with me on LinkedIn! linkedIn

#proudtobeasuperuser 

@tackytechtom 

Thank you very much , it work fine now.

Helpful resources

Announcements
November Power BI Update Carousel

Power BI Monthly Update - November 2025

Check out the November 2025 Power BI update to learn about new features.

Fabric Data Days Carousel

Fabric Data Days

Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.

Top Solution Authors
Top Kudoed Authors