Hide grand totals in matrix export

[Anonymous]

I want to export my matrix as it looks:

• The '% Matched' column is actually the column subtotals.
• The matrix values are given by the following measure: 

% Match =
 IF(
    HASONEFILTER(REP_ARC_TO_SOS_DETAIL[_SalesOption]),
    FORMAT(COUNT(REP_ARC_TO_SOS_DETAIL[ContainsCode]), "0%"),
    FORMAT(COUNT(REP_ARC_TO_SOS_DETAIL[_SalesOption])/[SelectedSalesOptions],"0%")
 )

But it exports like this:

Can I disable the grand totals in the export?

[Ritaf1983 · Accepted solution]

Hi @Anonymous 
The export layout of a matrix in Power BI mirrors how it is displayed in the report.
If the row grand total is visible in the matrix, it will also appear in the export.
To exclude the grand total from the exported matrix, you simply need to turn off the row grand total in the matrix’s formatting settings.

As long as it's shown in the visual, it will be included in the export as well.

If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly

[Anonymous]

The grand totals are not displayed in my visual, but display in the export.

[Anonymous]

There is no option to turn the grand totals on/off - only format them. They also do not display on my matrix.

[v-sshirivolu]

Hi  @Anonymous ,
Thank you for the follow up question !
If you're using an older version of Power BI Desktop, the option to disable grand totals might not be available.

If the response has addressed your query, please Accept it as a solution and give a 'Kudos' so other members can easily find it.

Regards,
Sreeteja.

[v-sshirivolu]

Hi @Anonymous 

I wanted to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions. If our response has addressed your query, please Accept it as a solution so that other community members can find it easily.

Thank you.

[v-sshirivolu]

Hi @Anonymous  !
May I ask if you have resolved this issue? If so, please mark the helpful reply and Accept it as the solution. This will be helpful for other community members who have similar problems to solve it faster.

Thank you.

[collinq]

hi @Anonymous ,

As far as I know , there is no way to turn this off on the export.  The export function does not give us the ability to select what parts come in the export.  There are a few ideas out there in the ideas forum for modifying this behaviour.  Please vote for one there or create your own!

[Anonymous]

😮