Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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
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.
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?
Consider using Paginated Reports. Fair warning: steep learning curve.
User | Count |
---|---|
98 | |
90 | |
82 | |
70 | |
67 |
User | Count |
---|---|
115 | |
104 | |
101 | |
72 | |
64 |