Forum Discussion
Exporting Matrix Visual to Excel
Hello!
I am trying to export to Excel a matrix visual, I have placed the values to be shown on rows. This is what the matrix looks like in PowerBI Service:
However, when I export it using Data wtih Current Layout option, this is what I get in Excel:
Any help would be appreciated!
Hi pulpfiction ,
According to my current test, it is normal, you can use my template for testing and compare with your own, also, is it possible to provide your pbix file, I will use your file for testing, remember to delete confidential data.
Did I answer your question? Mark my post as a solution!
Best RegardsLucien
4 Replies
Hi pulpfiction ,
According to my current test, it is normal, you can use my template for testing and compare with your own, also, is it possible to provide your pbix file, I will use your file for testing, remember to delete confidential data.
Did I answer your question? Mark my post as a solution!
Best RegardsLucien
You have chosen to "show values on rows" . Excel does not understand that feature. If this is important to you please consider raising it at https://ideas.powerbi.com
Hello,
Apart from the idea there is a workaround here that I would like to share, please check if that helps
Solved: Exporting a Matrix visual to Excel - Microsoft Power BI Community
Ritesh
Mark my post as a solution if it helped you| Munde and Kudis (Ladies and Gentlemen) I like your Kudos!! !!
My You Tube Channel !! Connect on LinkedinHi pulpfiction ,
Has your problem been solved, if so, please consider Accept a correct reply as the solution or share your own solution to help others find it.
Best Regards
Lucien
