cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Strebl
Frequent Visitor

Move Column Headers into multiple rows

Hello,

 

Sorry, I am completely new to Power BI, so I am looking for a way to transform my data table.

 

Power BI Original.PNG

 

 

 

 

 

 

 

Is there a way to move all column headers into rows?

I want the final result to be three columns - the first one with the years (12 times each), the second one with the months and the third column with the respective figures?

 

Thank you in advance,

Best regards,
Stefan

1 ACCEPTED SOLUTION
nsrshkh1
Resolver IV
Resolver IV

@Strebl 

 

You can do this via EditQuery using Unpivot option

Edit Query - Transform - Unpivot Columns (Any Column sub group)

select Overnights column (in your case) and use Unpivot Other Columns

Edit Query.png

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Proud to be Datanaut!

View solution in original post

1 REPLY 1
nsrshkh1
Resolver IV
Resolver IV

@Strebl 

 

You can do this via EditQuery using Unpivot option

Edit Query - Transform - Unpivot Columns (Any Column sub group)

select Overnights column (in your case) and use Unpivot Other Columns

Edit Query.png

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Proud to be Datanaut!

View solution in original post

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

November Power BI Update 768x460.png

Check it Out!

Click here to read more about the November 2021 Updates!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.