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 a...
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!

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

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