Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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!
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 | ID | Program | Level | Certification | Current Status | Location | Manager Name | Education | Hobbies |
Dean | 1 | BBC | Manager | Pass | Active | VA | Jason | Bachelors | Golfing |
Charles | 2 | MLL | Vice President | Pass | Active | CA | Lauren | Masters | Swimming |
Monica | 3 | BBC | President | Pass | Active | CO | Tuwana | Masters | Snowboarding |
Susie | 4 | BBC | Manager | Pass | On Leave | MD | Dennis | Bachelors | Fishing |
Keilah | 5 | LLC | Associate | Pass | Active | FL | Won | Bachelors | Fishing |
What is your preferred sort order? Have you considered unpivoting the data in Power Query instead?
User | Count |
---|---|
5 | |
4 | |
4 | |
2 | |
2 |
User | Count |
---|---|
8 | |
4 | |
4 | |
4 | |
3 |