Forum Discussion
Matrix Visual Export to Excel Columns
HI RLSid17 ,
No you can't as this shows the calculation you are trying to represent on the matrix visual.
One thing you can do is rename to a sensible name like Grouped Response rather than First Grouped Response in your matrix visual. This needs to be done in PBI Desktop and then publish report again to PBI service to export the matrix data.
HI RLSid17 ,
Just publish your report to power BI service and there you will get option to export your matrix visual as it is.
See below the matrix visual I have:
Once I export data:
I get an option to export it using Current layout:
The exported data is exactly same as matrix visual:
Thanks! This works but I have one query, would it be possible to remove the columns (highlighted in yellow) as I'm aiming it to be as simple as possible for reporting purposes:
HI RLSid17 ,
No you can't as this shows the calculation you are trying to represent on the matrix visual.
One thing you can do is rename to a sensible name like Grouped Response rather than First Grouped Response in your matrix visual. This needs to be done in PBI Desktop and then publish report again to PBI service to export the matrix data.
Thank you so much for the quick response! Initially, I was trying to export using the summarized data but never though to use Data with current layout.
