Exporting Matrix Visual to Excel

[pulpfiction]

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! 

[v-luwang-msft]

Hi @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

[v-luwang-msft · Accepted solution]

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 Regards

Lucien

[ribisht17]

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 Linkedin

[lbendlin]

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