Forum Discussion
Solved
Matrix data export to EXcel
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
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
1 Reply
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