Exporting Matrix Visual to Excel (or show in table view) - do not want totals displayed

[Anonymous]

Hi, 

I have a matrix visual that I have chosen not to display any totals - grand, row, or column - I just want the result values.  I have turned off all the total options.  The matrix visual looks as desired.  However when view the matrix as 'show in table view' or export to Excel, the row header totals display.  Is there any way to have them not display/export?  I've tried 'hiding' them by changing the font color to be the same as the background, but that does not work for table view/export.  Please see the screenshot below as an example.

Any help would be greatly appreciated.

thanks!

CJ

[parry2k]

@Anonymous glad you have a solution, cheers!

[parry2k]

@Anonymous  the option in Power BI service, Data with current layout might work for you.

Export to Excel Improvements for Table and Matrix Visuals (Preview) | Microsoft Power BI Blog | Microsoft Power BI

✨ Follow us on LinkedIn and  to our YouTube channel

I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make effort to give Kudos to whoever helped to solve your problem. It is a token of appreciation!

⚡ Visit us at https://perytus.com, your one-stop shop for Power BI-related projects/training/consultancy.

[Anonymous · Accepted solution]

Hi parry2k!

I did a little more digging into the exporting and have a workaround....as long as all the data is expanded, the export works and the totals are not dispplayed

Thanks again!

[Anonymous]

Thanks for the suggestion parry2k.

I am using the Data with current layout option when exporting, but I think because it currently does not support any formatting or coloring, it's not honoring my matrix visual settings.

CJWash