Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now
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
Desired output
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
PBI desktop in a table control
Thanks in advance
Solved! Go to Solution.
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 🙂
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 👍
Check out the October 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
69 | |
61 | |
18 | |
16 | |
13 |