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

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

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
LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

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