Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
105 | |
101 | |
79 | |
73 | |
65 |
User | Count |
---|---|
141 | |
107 | |
100 | |
82 | |
74 |