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

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

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

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.If the answer is helpful, please click Accept Answer and kindly upvote it so that other people who faces similar issue may get benefitted from it.
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 check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions. If my response has addressed your query, please Accept it as a solution so that other community members can find it easily.

Regards,
Harshitha.


Helpful resources

Announcements
July PBI25 Carousel

Power BI Monthly Update - July 2025

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

Join our Fabric User Panel

Join our Fabric User Panel

This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.

June 2025 community update carousel

Fabric Community Update - June 2025

Find out what's new and trending in the Fabric community.