Forum Discussion
Helper IIPower BI Matrix Export to excel
Hi There,
I have a matrix setup in Power bi. The problem is the users need to export it to excel for formatting but when exporting the columns and rows are switched around.
This is what the matrix looks like in Power BI:
But when I export to excel it looks like this:
As you can see the ValueDate_month and year are all now columns. How can I export this to show correctly?
Kind Regards,
Hi Annemie19 ，
Check the similar thread below:
Best Regards,
KellyDid I answer your question? Mark my post as a solution!
5 Replies
PaulDBrownCommunity Champion
You mght want to try out the free tool provided by the gurus at sqlbi.com
https://www.sqlbi.com/tools/analyze-in-excel-for-power-bi-desktop/
Annemie19Thanks a lot Paul,
The users are exporting from the browser app.
Is there no such solution for this?
v-kelly-msftCommunity Support
Hi Annemie19 ，
Check the similar thread below:
Best Regards,
KellyDid I answer your question? Mark my post as a solution!
- amitchandak
Super User
Annemie19 , I think it is typically data export not the formatted data export. You can try the tool suggested by PaulDBrown .
