Skip to main content

Power BI

Needs Votes

Enable 'total row' also to be exported.

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

a3309361 99be-ea11-a812-000d3a8ddfb2 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

a3309361 99be-ea11-a812-000d3a8ddfb2 on 05 Jul 2020 23:13:48

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

Would help a lot!!!

's profile image Profile Picture

98d7fd5d 14cd-4f97-a714-a1c928e44f97 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

871d0d0b 3572-46c9-9764-8951e97c581f 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

cc8d446e cbbf-4f7f-aaf7-97827bc41de8 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

f354a310 96f6-4b0b-ac43-746752f0f2dc 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.