web
You’re offline. This is a read only version of the page.
close
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.