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

Transpose a column with month name to Rows

Hi!

 

I have the below query that i want to transpose, but when I try, it does not convert the months into rows.

2019-12-24 11_18_29-Personal budget - Power Query Editor.pngBefore

 

2019-12-24 11_18_49-Personal budget - Power Query Editor.pngafter

can you guys assist?

 

 
1 ACCEPTED SOLUTION

Accepted Solutions
fhill Senior Member
Senior Member

Re: Transpose a column with month name to Rows

Make sure you have ALL the Month Columns selected / highlighted Before clicking 'Unpivot Columns'.  This will then give you Cat & SubCat as columns, with 'Attribute' as the Months and 'Value' as the cooresponding Values.

 

P.S.  Unless you specificlly want it, I would delete the Total Column before Unpivot'ing.  You can add this up later easier than maintaing the Total Row...

 

FOrrest

View solution in original post

3 REPLIES 3
Super User IV
Super User IV

Re: Transpose a column with month name to Rows

Screenshot or Query is missing. Please share

 

Thanks
My Recent Blog -

https://community.powerbi.com/t5/Community-Blog/HR-Analytics-Active-Employee-Hire-and-Termination-tr...





Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
In case it does not help, please provide additional information and mark me with @
My Recent Blogs -Decoding Direct Query - Time Intelligence, Winner Coloring on MAP,
HR Analytics, Power BI Working with Non-Standard TimeAnd Comparing Data Across Date Ranges
Proud to be a Super User! Linkedin


robertalvarez Frequent Visitor
Frequent Visitor

Re: Transpose a column with month name to Rows

Thanks AC, I was having issues with the upload.

 

Images should be visible now.

fhill Senior Member
Senior Member

Re: Transpose a column with month name to Rows

Make sure you have ALL the Month Columns selected / highlighted Before clicking 'Unpivot Columns'.  This will then give you Cat & SubCat as columns, with 'Attribute' as the Months and 'Value' as the cooresponding Values.

 

P.S.  Unless you specificlly want it, I would delete the Total Column before Unpivot'ing.  You can add this up later easier than maintaing the Total Row...

 

FOrrest

View solution in original post

Helpful resources

Announcements
Coming Soon: T-Shirt Design Contest

Coming Soon: T-Shirt Design Contest

Keep your eyes open for our upcoming T-shirt design contest!

Meet the 2020 Season 1 Power BI Super Users!

Meet the 2020 Season 1 Power BI Super Users!

It’s the start of a new Super User season! Learn all about the new Super Users and brand-new tiered recognition system.

Super User Challenge: Can You Solve These?

Super User Challenge: Can You Solve These?

We're celebrating the start of the New Super User season with our first ever Super User 'Can You Solve These?' challenge.

Power Platform Online Conference

Power Platform Online Conference

Join us for the first ever Power Platform Online Conference!

Top Solution Authors
Top Kudoed Authors