Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

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.

Reply
Anonymous
Not applicable

When exporting from Matrix Table Visuals columns are in wrong order

Hi Team,

 

Our client noticed that when using the Dashboard online, exporting from the Matrix visual as "Data with current layout", the columns are exported in wrong order, more specfically whatever field is inserted in "Rows" when designing the visual, that field ends up at the very end of the export. Wondering if this is by design or a bug when exporting data from "Matrix" visual. 

 

Current workaround is to export as "Summarized data".

 

1 ACCEPTED SOLUTION
v-easonf-msft
Community Support
Community Support

Hi, @Anonymous 

This feature is still in preview, the issues has been mentioned in the comments section of the blog. 
Export to Excel Improvements for Table and Matrix Visuals (Preview) 

As far as I know, a similar issue has also been submitted internally.  (Internal ICM ID:274258812) 

The engineers are still investigating the problem, please be patient.

You can also keep an eye on this related thread.

https://community.powerbi.com/t5/Service/Export-to-excel-data-with-current-layout-is-not-showing-current/m-p/2207129#M145511 

 

Best Regards,
Community Support Team _ Eason

View solution in original post

2 REPLIES 2
v-easonf-msft
Community Support
Community Support

Hi, @Anonymous 

This feature is still in preview, the issues has been mentioned in the comments section of the blog. 
Export to Excel Improvements for Table and Matrix Visuals (Preview) 

As far as I know, a similar issue has also been submitted internally.  (Internal ICM ID:274258812) 

The engineers are still investigating the problem, please be patient.

You can also keep an eye on this related thread.

https://community.powerbi.com/t5/Service/Export-to-excel-data-with-current-layout-is-not-showing-current/m-p/2207129#M145511 

 

Best Regards,
Community Support Team _ Eason

lbendlin
Super User
Super User

It is not clear from your description what the issue is.  Export with current layout is supposed to mimic the exact layout of the matrix visual at the time of export. Can you show examples?

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors