Forum Discussion
Month as Column
Any idea of how I can move my months as the columns like in the picture below in the table visual?
4 Replies
Toots ,
Try transpose in Power Query.
Let me know if you have any questions.
If this solves your issues, please mark it as the solution, so that others can find it easily. Kudos are nice too.
NathanielHi,
- To go the query mode, selecting in the ribbon Home -> Edit Queries;
- Then select the columns months columns in the table, select the ribbon Transform -> Unpivot Columns -> Unpivot Selected Columns.
Look at this example:
If this helps, I apreciate you give a kudo and mark as the solution. Thanks
Hi There,
I am trying to do this in a visualization not in the tables themselves as the data is across a few tables
Tried to check with the sample data, but it is not possible in the visual level. we will modify the data in the edit queries window.
Please refer the below link.
http://www.mediafire.com/file/gb5b1cwywrad83d/UnPivot.pbix
If this post helps, then please consider Accept it as the solution to help the other members find it more
If this post was helpful may I ask you to mark it as solution and give it some kudos?
