Forum Discussion
Solved
Matrix question- Excel exporting
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...
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 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
Simple for sure but it usually messes with the order of the months in the columns