Skip to main content
Microsoft Idea

Power BI

Needs Votes

Enable 'total row' also to be exported.

Vote (690) Share
's profile image

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 (90)
's profile image Profile Picture

Power BI Ideas Admin on 05 Jul 2020 23:19:21

RE: Enable 'total row' also to be exported.

Please add this feature to the Exports. Clients seem to require this often and it would go a long way to helping make this a bit more streamlined.

's profile image Profile Picture

Sachin Pokhariyal on 05 Jul 2020 23:18:07

RE: Enable 'total row' also to be exported.

Required this feature, this is a basic need and available in BI Tools like QlikView

's profile image Profile Picture

Aalok Shah on 05 Jul 2020 23:16:39

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.

's profile image Profile Picture

Chanti on 05 Jul 2020 23:15:42

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...

's profile image Profile Picture

Power BI Ideas Admin on 05 Jul 2020 23:13:49

RE: Enable 'total row' also to be exported.

Please fix this, would help a lot!

's profile image Profile Picture

Power BI Ideas Admin on 05 Jul 2020 23:13:48

RE: Enable 'total row' also to be exported.

Would help a lot!!!

's profile image Profile Picture

Charles on 05 Jul 2020 23:10:40

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...

's profile image Profile Picture

B. Bartlome on 05 Jul 2020 23:09:54

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.

's profile image Profile Picture

John Parillo on 05 Jul 2020 23:07:16

RE: Enable 'total row' also to be exported.

This feature would be help to us as well!

's profile image Profile Picture

Jo Price on 05 Jul 2020 23:04:10

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.