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.
I have the below matrix and was trying to figure out a way to export to Excel in the same format with all the month columns listed out. As you can see in the 2nd snippet, the months are broken out in rows in stead of columns up top. Is there a way to alter the export format? Perhaps another visual instead of matrix would solve the issue but I'm not sure. Appreciate any insight!
Solved! Go to Solution.
Hi dmoney7612,
When you export matrix visual, data gets unpivoted in the exported excel.
You need to make a pivot table after exporting data into excel to get the same matrix visual look.
Appreciate a Kudos! 🙂
If this helps and resolves the issue, please mark it as a Solution! 🙂
Regards,
N V Durga Prasad
FYI, this feature is now live in preview mode (service only not desktop AFAIK):
https://ideas.powerbi.com/ideas/idea/?ideaid=b33fc4b3-9dae-4356-973d-d5ffe635ce15
A few bugs with column headers in preview, but definitely a welcome enhancement.
FYI that this feature that is coming out in October. Until then, making a pivot from the exported data is pretty quick to do once you've done it a couple times.
Export to Excel improvements for table and matrix visuals | Microsoft Docs
Pat
To learn more about Power BI, follow me on Twitter or subscribe on YouTube.
Simple for sure but it usually messes with the order of the months in the columns
Hi dmoney7612,
When you export matrix visual, data gets unpivoted in the exported excel.
You need to make a pivot table after exporting data into excel to get the same matrix visual look.
Appreciate a Kudos! 🙂
If this helps and resolves the issue, please mark it as a Solution! 🙂
Regards,
N V Durga Prasad
That's what I figured. So there is no work around or another visual that would export better?
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 |
---|---|
104 | |
95 | |
80 | |
67 | |
62 |
User | Count |
---|---|
146 | |
110 | |
107 | |
86 | |
63 |