Forum Discussion

TanHY's avatar
TanHY
Helper I
1 year ago
Solved

Matrix Table export data- Total Naming is different

This is power bi UI table - the total is "Total by Company" However, when the user export the data into CSV, it will reverted back to "Total" Is there anyone facing this issue befor...
Need Help
Tips and Tricks
  • Anonymous's avatar
    Anonymous
    1 year ago

    Hi TanHY ,

    Yes, this is something a number of users have come across. Power BI allows us to rename subtotal rows in the matrix visual (e.g., "Total by Company"), but when exporting to CSV, it defaults back to just "Total". This is a known behavior and currently by design.

    A possible workaround is using Excel export instead of CSV which retains more formatting, or applying a custom DAX label in the matrix to mimic the behavior.

    Does this workaround or explanation help with your scenario? Let us know if you’ve found a different way around it.

    Thanks.

    If this response helps, consider marking it as “Accept as Solution” and giving a kudos to assist other members as well.

    Regards,
    Akhil.

Anonymous's avatar
Anonymous
Not applicable
1 year ago

Hi TanHY ,

Hi there, just checking in were you able to sort out the matrix subtotal label issue? Curious if the Excel export or custom DAX label workaround did the trick. Happy to help if you're still exploring options.

Regards,
Akhil.