Forum Discussion
dmoney7612
5 years agoHelper II
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...
- 5 years ago
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
sfmike99
4 years agoAdvocate II
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.