Formatting in visual is not preserved when exporting off PowerBI website (value in rows)

[powerjey]

Hi everyone, 

I'm having trouble maintaining the formatting I have when my matrix has the "values in rows" selection on. The resulting export excel file is the default column format. Anyone help here? 

 

 

[devarajns]

Try Inforiver.com Pro version trial

[Anonymous]

Hi @powerjey ,

Have you choose the option "Data with current layout" to export the matrix?

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

Best Regards,

Jay

[powerjey · Accepted solution]

I actually did a workaround where I unpivoted the columns I needed and added them as a subcategory in the matrix row 

[powerjey]

Any help?