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.
Hi!
I have the below query that i want to transpose, but when I try, it does not convert the months into rows.
can you guys assist?
Solved! Go to Solution.
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
Proud to give back to the community!
Thank You!
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
Proud to give back to the community!
Thank You!
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...
Thanks AC, I was having issues with the upload.
Images should be visible now.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
109 | |
99 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
102 | |
87 | |
64 |