How to export data to excel to proper format

Hello TriveniN ,

to have in the same format you should export it from Power BiI service as in the following article

https://powerbi.microsoft.com/en-cy/blog/export-to-excel-improvements-for-table-and-matrix-visuals-preview/

If I answered your question, please mark my post as solution, Appreciate your Kudos 👍

Follow me on Linkedin
Vote for my Community Mobile App Idea 💡

Hi TriveniN 
To export the matrix to Excel in the same layout as in the pbi report you should select the option "Data with current layout" when you export it.
Unfortunately, I am out of the limit of screenshots that I can add to the discussions so I recorded my screens to show how it works you can download it from the  attached link:
The link to mp4 

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