on 05 Jul 2017 02:56:06
Now when we export data from matrix visual in PBI Desktop to an Excel file - the 'Total' row does not get exported to Excel though that is visible in PBI Desktop. Please fix it.
- Comments (88)
RE: Enable 'total row' also to be exported.
There is no point in showing data in matrix with totals in UI but not being able to export totals in excel.
This is a very much required feature.
RE: Enable 'total row' also to be exported.
It's very useful option and required for analysis any one had any luck on grand totals or sub totals into excel...
RE: Enable 'total row' also to be exported.
Please fix this, would help a lot!
RE: Enable 'total row' also to be exported.
Would help a lot!!!
RE: Enable 'total row' also to be exported.
Created my Matrix table with sub and grand totals -- it looks great on desktop and Web UI. However, when exporting none of the totals transfer to the .csv or .xlsx. This is a shame because now I have to ask my end users to re-tally up all the data in excel.
Furthermore, it's a bit scary because some of my totals are weighted -- I can easily envision a user just averaging a column and sharing the excel -- BAM! Wrong data being shared accross the company...
RE: Enable 'total row' also to be exported.
Desperately needed feature, as some information can't be calculated based on the data in the rows.
RE: Enable 'total row' also to be exported.
This feature would be help to us as well!
RE: Enable 'total row' also to be exported.
This would be incredibly useful. I have clients who just want to export what they see in PBI into Excel and not have to worry about re-pivoting the data afterwards.