Forum Discussion

Frequent Visitor

6 years ago

Month as Column

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

Resolver III

6 years ago

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-value-How/m-p/818703#M393500

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

Toots
Frequent Visitor
6 years ago
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
  Memorable Member
  6 years ago
  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?

Related content