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

Johnny Ampuero on 14 Oct 2020 15:00:32

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

The ability of having the Total row exportable to Excel should have been present since the release of the Matrix visual. Hopefully the Power BI team implements it soon.

's profile image Profile Picture

Andrea Caccamisi on 12 Oct 2020 15:00:47

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

This is critical, how cannot be there yet?

's profile image Profile Picture

Luciana on 06 Jul 2020 00:17:00

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

where are the totals and subtotals on my excel exported file?? need it ASAP!!

's profile image Profile Picture

Brian Helms Jr on 06 Jul 2020 00:16:12

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

This is a basic. Power BI has so much visual power and pitiful data exporting ability.

's profile image Profile Picture

Power BI User on 06 Jul 2020 00:13:48

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

Please add feature of subtotal and grand total rows to be exported as well.

's profile image Profile Picture

Power BI User on 06 Jul 2020 00:13:34

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

Everyone needs a totals row. This should be a top priority fix.

's profile image Profile Picture

Power BI User on 06 Jul 2020 00:13:06

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

Please enable 'total row' and also 'subtotal row' to be exported.This is a necessary requirement so Power BI can meet all of my reporting needs.

's profile image Profile Picture

RAJENDRA BOBADE on 06 Jul 2020 00:12:50

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

The 'Total' row does not get exported to Excel though that is visible in PBI Desktop. Please fix it
please trying to resolve this as soon as possible

for workaround we are using below information

we are using "Analyze in Excel " option found in power bi Services we can use this option so we get all data and calculated fields in excel.

's profile image Profile Picture

Power BI User on 06 Jul 2020 00:12:31

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

Please enable to export subtotals and totals to excel

's profile image Profile Picture

Charlie on 06 Jul 2020 00:11:31

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

This is a MUST have, we need WYSIWYG behavior on table reports in PBI service!