Forum Discussion
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...
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.
