Matrix visual - show dates in rows instead of columns

[nitinbalodi]

Hello all, is there any way we can transpose rows and columns in matrix visual. I am checking if we can expand dates as column headers instead of row headers. Image attached for reference. Thanks in advance for support.

[v-yiruan-msft]

Hi @nitinbalodi ,

What did this data referenced to the matrix originally look like? Could you please provide some example data in your tables (exclude sensitive data) with Text format and your expected result with backend logic and special examples. It is better if you can share a simplified pbix file.

And how did you set up your matrix (Rows:???  Columns:????  Values:???)? You may consider putting the fields that were originally placed in the Rows option into the Columns option as shown below to achieve your needs...

Best Regards

[amitchandak]

@nitinbalodi , I do not see dates in column

You can date in column of Matrix

You can use Show values on Row - To show values/measures on row

For complex display Calculation Groups- Measure Slicer, Measure Header Grouping, Measure to dimension conversion. Complex Table display : https://youtu.be/qMNv67P8Go0