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

Vote for your favorite vizzies from the Power BI Dataviz World Championship submissions. Vote now!

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
Sticker Challenge 2026 Carousel

Join our Community Sticker Challenge 2026

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!

January Power BI Update Carousel

Power BI Monthly Update - January 2026

Check out the January 2026 Power BI update to learn about new features.

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.