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

Get certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now

Reply
swathiG
New Member

How to add multiple rows side by side in matrix visual

Hi Can any one help me add multiple rows side by side in matrix visual.
in the below attached SS I have Geo below which I have services Now I want to add services as a column in matrix visual
please anyone help to figure it out.

I have tried to enable the stepped layout  from row headers but I dont see that oprion in my desktop

swathiG_0-1731142808807.png

swathiG_1-1731142980747.png

#power BI #PowerBI desktop

 

2 ACCEPTED SOLUTIONS
shafiz_p
Resident Rockstar
Resident Rockstar

Hi @swathiG  Go to layout and style and set layout to Tabular or outline. Follow red highlighted steps.

shafiz_p_0-1731143480299.png

 

 

Hope this helps!!

If this solved your problem, please accept it as a solution and a kudos!!

 

Best Regards,
Shahariar Hafiz

View solution in original post

Bibiano_Geraldo
Memorable Member
Memorable Member

Hi, @swathiG , folow these steps:

 

1. Make sure to put fields that you want in rows:

Bibiano_Geraldo_0-1731151648900.png

 

2.In visual format, go to Layout and Style Pressets and change the layout to tabular, and the active toggle button to repeat headers as shown bellow:

Bibiano_Geraldo_1-1731151854264.png

 

3. Now you can Expand all down levels in the hierarchy as shown bellow:
Bibiano_Geraldo_3-1731152246552.png

 

 

4.Now your Matrix should look like this:

Bibiano_Geraldo_2-1731151903536.png

 

To learn more about Matrix, please follow the link: Matrix visual format settings 

If this help you, please give a Kudo and mark as solution

I hope this helps! 
If you found this answer helpful:
✔️ Mark it as the solution to help others find it faster.
 Give it a like to show your appreciation!

Thank you for contributing to our amazing Power BI community! 

View solution in original post

3 REPLIES 3
v-xianjtan-msft
Community Support
Community Support

Hi @swathiG 

 

First of all, thanks to shafiz_p and Bibiano_Geraldo for their replies.

Both shafiz_p and Bibiano_Geraldo have provided good advice, if these helped you to solve your problem, please consider accepting their replies as a solution that will benefit other users who want to seek an answer to this question.

 

Best Regards,
Jarvis Tang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Bibiano_Geraldo
Memorable Member
Memorable Member

Hi, @swathiG , folow these steps:

 

1. Make sure to put fields that you want in rows:

Bibiano_Geraldo_0-1731151648900.png

 

2.In visual format, go to Layout and Style Pressets and change the layout to tabular, and the active toggle button to repeat headers as shown bellow:

Bibiano_Geraldo_1-1731151854264.png

 

3. Now you can Expand all down levels in the hierarchy as shown bellow:
Bibiano_Geraldo_3-1731152246552.png

 

 

4.Now your Matrix should look like this:

Bibiano_Geraldo_2-1731151903536.png

 

To learn more about Matrix, please follow the link: Matrix visual format settings 

If this help you, please give a Kudo and mark as solution

I hope this helps! 
If you found this answer helpful:
✔️ Mark it as the solution to help others find it faster.
 Give it a like to show your appreciation!

Thank you for contributing to our amazing Power BI community! 
shafiz_p
Resident Rockstar
Resident Rockstar

Hi @swathiG  Go to layout and style and set layout to Tabular or outline. Follow red highlighted steps.

shafiz_p_0-1731143480299.png

 

 

Hope this helps!!

If this solved your problem, please accept it as a solution and a kudos!!

 

Best Regards,
Shahariar Hafiz

Helpful resources

Announcements
November Carousel

Fabric Community Update - November 2024

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

Live Sessions with Fabric DB

Be one of the first to start using Fabric Databases

Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.

Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.

Nov PBI Update Carousel

Power BI Monthly Update - November 2024

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