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

Power BI is turning 10! Let’s celebrate together with dataviz contests, interactive sessions, and giveaways. Register now.

Reply
JamesShawPBI
Frequent Visitor

Transpose of a matrix or moving dates to columns

Hi Guys,

 

I have a matrix that displays all my data, execpt I have been asked to put the dates across the page and the data down the page (the transpose of the matrix in the image).

I have tried moving "Date" to Columns field and Values to the "Rows" field but the software won't let me.

Is there a way for me to get dates across the page and the rest of the data going down the page?

Thanks

 

image.png

 

 

 

1 ACCEPTED SOLUTION
PaulDBrown
Community Champion
Community Champion

You need to change the Dates field by moving it from the rows bucket to the columns bucket (leave the rows bucket empty):

move to columns.png

 

Next search for "Switch" in the formatting pane and turn on the "Switch values to rows" under Values ->options

columns.png

 





Did I answer your question? Mark my post as a solution!
In doing so, you are also helping me. Thank you!

Proud to be a Super User!
Paul on Linkedin.






View solution in original post

1 REPLY 1
PaulDBrown
Community Champion
Community Champion

You need to change the Dates field by moving it from the rows bucket to the columns bucket (leave the rows bucket empty):

move to columns.png

 

Next search for "Switch" in the formatting pane and turn on the "Switch values to rows" under Values ->options

columns.png

 





Did I answer your question? Mark my post as a solution!
In doing so, you are also helping me. Thank you!

Proud to be a Super User!
Paul on Linkedin.






Helpful resources

Announcements
June 2025 Power BI Update Carousel

Power BI Monthly Update - June 2025

Check out the June 2025 Power BI update to learn about new features.

June 2025 community update carousel

Fabric Community Update - June 2025

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