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

Create a table with field name and values in rows

Hello community, 

I am wanting to create a table for a person profile with field name and values in rows. The issue with the table visual is that the fields run across in columns. In the screenshot below with sample data, the left is how the table is appearing, and the right is how I would like the table to look. Any help is appreciated! thank you!

 

mlim0806_0-1706060131518.png

 

3 REPLIES 3
Anonymous
Not applicable

Hi @mlim0806 ,

Can you please share a pbix or some dummy data that keep the raw data structure with expected results? It should help us clarify your scenario and test to coding formula.

How to Get Your Question Answered Quickly  

Regards,

Xiaoxin Sheng

It does not look like I have permission to share pbix files. Will this pasted sample data help?

Name IDProgramLevelCertificationCurrent StatusLocationManager NameEducationHobbies
Dean1BBCManagerPassActiveVAJasonBachelorsGolfing
Charles2MLLVice PresidentPassActiveCALaurenMastersSwimming
Monica3BBCPresidentPassActiveCOTuwanaMastersSnowboarding
Susie4BBCManagerPassOn LeaveMDDennisBachelorsFishing
Keilah5LLCAssociatePassActiveFLWonBachelorsFishing
lbendlin
Super User
Super User

What is your preferred sort order?  Have you considered unpivoting the data in Power Query instead?

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.