Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

0

Matrix visual adding total row to the table in focus mode as well as export

Hello,

 

I have turned off all row and column totals in my matrix visual, however, when I go focus mode row totals appears in the table. Same thing happens when I try to export to exel directly from the matrix visual. Is this a bug? I do not want the row to show.

 

See yellow lines in screenshots:

reggiebob_0-1694537225190.png

 

reggiebob_1-1694537225200.png

 

Status: Delivered

Hi @reggiebob ,

Refer this document, if the Row subtotals toggle is set to 'Off' in Power BI Desktop for a matrix visual, but the matrix visual has expanded and collapsed sections, exported data will contain subtotals for rows.

If you would like to suggest  feature improvements, you may vote the idea and comment here to improve this feature. It is a place for customers provide feedback about Microsoft Office products . What’s more, if a feedback is high voted there by other customers, it will be promising that Microsoft Product Team will take it into consideration when designing the next version in the future.

Best Regards,

Community Support Team _ Neeko

Comments
v-tangjie-msft
Community Support
Status changed to: Delivered

Hi @reggiebob ,

Refer this document, if the Row subtotals toggle is set to 'Off' in Power BI Desktop for a matrix visual, but the matrix visual has expanded and collapsed sections, exported data will contain subtotals for rows.

If you would like to suggest  feature improvements, you may vote the idea and comment here to improve this feature. It is a place for customers provide feedback about Microsoft Office products . What’s more, if a feedback is high voted there by other customers, it will be promising that Microsoft Product Team will take it into consideration when designing the next version in the future.

Best Regards,

Community Support Team _ Neeko