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

Calling all Data Engineers! Fabric Data Engineer (Exam DP-700) live sessions are back! Starting October 16th. Sign up.

Reply
sandygather
Frequent Visitor

Help with Matrix visualisation

Hi All,

I am new to Power BI and trying to work out if we can create something similar to Screenshot 1 in Power BI. Please note that Values here are actually Measures and remaining are all Dimensions. I can show the Measures in Row but as soon I add dimensions, it shows up like in Screenshot 2

Screenshot 1

Matrix.jpg

Screenshot 2

Matrix_PowerBI.jpg

1 ACCEPTED SOLUTION

Hi @sandygather,

You want to show Network Type under Measure Type in the rows, just like in Screenshot 1 you shared earlier.

If you change column to rows then you will get the excepted output.I tested it with my sample data, and it worked fine. Please find the attached screenshot and Pbix for your reference.

vhjannapu_0-1752641633869.png


Hope the above provided information help you resolve the issue, if you have any further concerns or queries, please feel free to reach out to us.
Regards,
Harshitha.

View solution in original post

6 REPLIES 6
v-hjannapu
Community Support
Community Support

Hi @sandygather,

Thank you  for reaching out to the Microsoft fabric community forum.
The matrix is not showing the dimensions the way you want. To fix it, try adding NetworkType first and then SpeedTier under Columns, and put MeasureType in Rows. Also, go to the matrix format settings and turn off the stepped layout .that should give you the layout like your Screenshot 1.
I tested it with my sample data, and it worked fine. Please find the attached Pbix for your reference.

Hope the above provided information help you resolve the issue, if you have any further concerns or queries, please feel free to reach out to us.
Regards,
Harshitha.

Hi @sandygather,
I hope the information provided above assists you in resolving the issue. If you have any additional questions or concerns, please do not hesitate to contact us. We are here to support you and will be happy to help with any further assistance you may need.

Regards,
Harshitha.


Hi @v-hjannapu ,

Thanks for your response. 

I had a look at your recommendation but it does not appear to fulfill my requirement. Below is what I got from your pbix file. However, my requirement is to show Netwrok Type under Measure Type in the rows. Please refer to my original post Screenshot 1

sandygather_0-1751933570696.png

 

Hi @sandygather,

You want to show Network Type under Measure Type in the rows, just like in Screenshot 1 you shared earlier.

If you change column to rows then you will get the excepted output.I tested it with my sample data, and it worked fine. Please find the attached screenshot and Pbix for your reference.

vhjannapu_0-1752641633869.png


Hope the above provided information help you resolve the issue, if you have any further concerns or queries, please feel free to reach out to us.
Regards,
Harshitha.

Hi @sandygather,
I hope the above details help you fix the issue. If you still have any questions or need more help, feel free to reach out. We’re always here to support you.

Regards,
Harshitha.

Hi @sandygather,

I wanted to follow up and see if you have had a chance to review the information that was shared. If you have any additional questions or need further clarification, please don’t hesitate to reach out. I am here to assist with any concerns you might have.

Regards,
Harshitha.

Helpful resources

Announcements
FabCon Global Hackathon Carousel

FabCon Global Hackathon

Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes!

October Power BI Update Carousel

Power BI Monthly Update - October 2025

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

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