Matrix data export to EXcel

[INJAINP]

Hello People, I have a doubt. I have created a Matrix visual in which I have material in rows , Week in a column and there are KPI in values. So when i export the data it does not get exported in the same form. Rather I have material , week and KPI in diff columns. Isn't it possible to have it exported in the same form as shown in matrix? are there any settings? Thanks Regards Priyanka

[v-yuta-msft · Accepted solution]

@INJAINP

Yes, click the ellipse on the top-right hand of the visual will export the raw data(original table) to csv file or excel file, not the format of a matrix data. As a workaround, you may try File-> Export to PDF instead in power bi desktop.

Reference: https://docs.microsoft.com/en-us/power-bi/desktop-export-to-pdf

Regards,

Jimmy Tao