Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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,
Solved! Go to Solution.
Hi @Annemie19 ,
Check the similar thread below:
Best Regards,
Kelly
Did I answer your question? Mark my post as a solution!
Hi there,
I got the same query from our users and hardluck cannot find the solution yet.
@MattAllington --> is there any other workaround/solution, please advise...
Thanks.
MAK.
@Annemie19 , I think it is typically data export not the formatted data export. You can try the tool suggested by @PaulDBrown .
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/
Proud to be a Super User!
Paul on Linkedin.
Thanks a lot Paul,
The users are exporting from the browser app.
Is there no such solution for this?
Hi @Annemie19 ,
Check the similar thread below:
Best Regards,
Kelly
Did I answer your question? Mark my post as a solution!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
107 | |
99 | |
76 | |
64 | |
58 |
User | Count |
---|---|
148 | |
113 | |
97 | |
84 | |
67 |