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

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
davidgray42
Frequent Visitor

Transpose rows to colums

Hi, 

In PowerBI / Power query  I'm looking to convert a single row of data to columns with the header row used as column one.  The example below is just a mockup in Excel.   

 

Original 

davidgray42_0-1704975787036.png

 

Desired output 

davidgray42_1-1704975814389.png

 

In the Powerquery editor I have used Transpose to turn my row(s) into column(s), howerver when I display in a table in PBI desktop the data is converted back to rows. What is the easiest way to acheive this? 

 

My dataset will contain multiple rows but only one can be displayed as I'm filtering on a single row slicer.   I can enforce a single row to be returned by the SQL server if that makes it easier to display as a vertical list? 

 

Powerquery

davidgray42_2-1704975930681.png

 

PBI desktop in a table control 

davidgray42_3-1704976092797.png

 

Thanks in advance

 

 

 

 

 

 

 

 

 

 

 

1 ACCEPTED SOLUTION
Einomi
Resolver II
Resolver II

Hi @davidgray42 

 

Load your table to Power Query

Select all columns then, on the Transform Tab > Unpivot all columns

 

Kudos and Accept as solution appreciated 🙂

View solution in original post

3 REPLIES 3
Einomi
Resolver II
Resolver II

Thanks @davidgray42 it is pleasure to help 🙂

Einomi
Resolver II
Resolver II

Hi @davidgray42 

 

Load your table to Power Query

Select all columns then, on the Transform Tab > Unpivot all columns

 

Kudos and Accept as solution appreciated 🙂

Wow, it was that staightforward 😁 

 

Thanks for your answer, works a treat now 👍

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

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

April Fabric Community Update

Fabric Community Update - April 2024

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

Top Solution Authors
Top Kudoed Authors