Month as Column

[Toots]

Any idea of how I can move my months as the columns like in the picture below in the table visual?

[mauriciosotero]

Hi,

- 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:

https://community.powerbi.com/t5/Desktop/Column-Header-is-a-Date-but-the-content-of-Column-is-a-valu...

If this helps, I apreciate you give a kudo and mark as the solution. Thanks

[Toots]

Hi There,

I am trying to do this in a visualization not in the tables themselves as the data is across a few tables

[venal]

@Toots 

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?

[Nathaniel_C]

@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.
Nathaniel