Export Matrix with Values in Rows

[Anonymous]

I have a matrix in a Power BI report, shown below, where values are in rows and months are in columns. I want this to export to Excel in the Exact same format, with values on rows and months on columns. However, when I export to .xlsx, either Data with Current Layout or Summarized data, the Excel report is produced with values on columns and months on rows (see second screenshot below). How can this be adjusted so I can export the file with values on rows? Thank you

[alono23]

@Anonymous did you find any solution to that problem?

[lbendlin]

You can correct this by not exporting.  Instead, use Analyze in Excel or "Excel with Live Connection"  and then recreate the desired format in Excel.

[Anonymous]

Thank you for the reply. This is a report a bunch of business users will be referencing, so I'd rather not have them need to reformat. Do you know of another matrix visual that allows for formatted exports?

[lbendlin]

Consider using Paginated Reports.  Fair warning: steep learning curve.