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
AndreasGu
Frequent Visitor

Split a list into multiple columns after each x element

Hello,

 

Is it possible to adjust a table/matrix in a form where I split a list into multiple columns after each x element?

 

The goal is to avoid scrolling and give a better overview on longer lists.

 

Like in the example i prepared in excel below, after 10 nationalities, I would like the list to add a second column with the list ongoing and the total at the end.

 

 

AndreasGu_0-1680514088900.png

 

Thank you for your feedback,

 

Best regards

Andreas

 

1 ACCEPTED SOLUTION
PhilipTreacy
Super User
Super User

Sorry @AndreasGu 

 

I don't believe this is possible.  You can't adjust the layout of a table or matrix in such a way.

 

Regards

 

Phil



Did I answer your question? Then please mark my post as the solution.
If I helped you, click on the Thumbs Up to give Kudos.


Blog :: YouTube Channel :: Connect on Linkedin


Proud to be a Super User!


View solution in original post

2 REPLIES 2
AndreasGu
Frequent Visitor

Thanks, Phil,

 

Actually, I was expecting that answer, unfortunately. 

PhilipTreacy
Super User
Super User

Sorry @AndreasGu 

 

I don't believe this is possible.  You can't adjust the layout of a table or matrix in such a way.

 

Regards

 

Phil



Did I answer your question? Then please mark my post as the solution.
If I helped you, click on the Thumbs Up to give Kudos.


Blog :: YouTube Channel :: Connect on Linkedin


Proud to be a Super User!


Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

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

July PBI25 Carousel

Power BI Monthly Update - July 2025

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