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

Marc MOURA on 25 Nov 2020 14:31:41

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

I don't understand how this simple request is not fixed yet...
Thanks by advance for fixing it, that's a very useful fonctionnality!!

's profile image Profile Picture

Denis Woods on 31 Oct 2020 08:31:07

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

Will not let me vote, why are Microsoft ignoring this most requested idea?

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