The matrix cannot export the current layout

Hann — Mon, 31 Oct 2022 12:29:43 GMT

The matrix cannot export the current layout. The option allows exporting

Re: The matrix cannot export the current layout

Anonymous — Tue, 01 Nov 2022 05:54:50 GMT

Hi Hann ,

For export from matrix visuals using Data with current layout, consider the following:
- Matrices with columns and/or values but no rows will be exported as having rows and/or values but no columns
- Matrices with only one row and/or values but no columns will be exported as table (no right border separator)
- If the Switch values to rows formatting option is set to 'On' in Power BI for a table or matrix visual, the visual format would not be preserved when data is exported to Excel
- If the Row subtotals toggle is set to 'Off' in Power BI Desktop for a matrix visual, but the matrix visual has expanded and collapsed sections, exported data will contain subtotals for rows. To work around this issue, use the Expand | All command from the visual's context menu.

Best Regards,
Community Support Team _ Caitlyn

If this post helps then please consider Accept it as the solution to help the other members find it more quickly.