Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

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

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

Need Help
  • Anonymous's avatar
    Anonymous
    3 years ago

    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!

4 Replies

  • parry2k's avatar
    parry2k
    Icon for Super User rankSuper User
    3 years ago

    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's avatar
      Anonymous
      Not applicable
      3 years ago

      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's avatar
      Anonymous
      Not applicable
      3 years ago

      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