Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
deckamaha
Frequent Visitor

Transpose table by a spesific Date column

Hi.

 

I have a question about transpose function in Power BI.Capture.JPG

 

 

 

 

 

 

 

The table above, looking at the data structure can be transposed by the DATE column, to be like thisaaa.JPG

 

 

 

 

 

 

 

 

I've been trying using the transpose function in the query editor, but the result is not how i think it suppose to be.

Can you help showing me how to use the transpose in the query editor to get the result like in the second picture?

 

Thanks.

 

 

1 ACCEPTED SOLUTION
TomMartens
Super User
Super User

Hey,

 

basically it's a good thing for the data model to have the measures in columns.

 

To achieve what you want, just use the Matrix visual from Power BI Desktop, drag the Month columns to the columns, the measure to values

 

And finally use the Option from the Formatting Pane of the Matrix visual to show the values on Rows

 

Mark the Visual

Format -> Values -> Switch "Show on rows" to on

 

Hopefully this is what you are looking for

 

Regards

Tom



Did I answer your question? Mark my post as a solution, this will help others!

Proud to be a Super User!
I accept Kudos 😉
Hamburg, Germany

View solution in original post

2 REPLIES 2
TomMartens
Super User
Super User

Hey,

 

basically it's a good thing for the data model to have the measures in columns.

 

To achieve what you want, just use the Matrix visual from Power BI Desktop, drag the Month columns to the columns, the measure to values

 

And finally use the Option from the Formatting Pane of the Matrix visual to show the values on Rows

 

Mark the Visual

Format -> Values -> Switch "Show on rows" to on

 

Hopefully this is what you are looking for

 

Regards

Tom



Did I answer your question? Mark my post as a solution, this will help others!

Proud to be a Super User!
I accept Kudos 😉
Hamburg, Germany

Well thanks for the help Smiley Happy

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.