Forum Discussion
exporting matrix visual to excel keeping the same format
hello everyone!
i have report where i want to export matrix to excel however the format is not the exact same after i export . im using conditional formating by another measure so when i export it returns the measure i used for conditional formatting within the measure inside the matrix
note that even when i choose the first option (data with current format) it doesnt export the same format
the matrix i have in power bi:
how it looks after i export:
Interesting. It does look like it's exporting conditional-formatting-related values too.
This is a relatively new feature, so I'd expect stuff like this to happen occasionally. You may want to bring it up in the Issues forum: https://community.powerbi.com/t5/Issues/ct-p/PBI_Comm_Issues
6 Replies
Interesting. It does look like it's exporting conditional-formatting-related values too.
This is a relatively new feature, so I'd expect stuff like this to happen occasionally. You may want to bring it up in the Issues forum: https://community.powerbi.com/t5/Issues/ct-p/PBI_Comm_Issues
Hi lawada ,
This issue has been submitted internally.（Internal ICM ID:274258812 ）
Please be patient to wait for fixing. If there is any news, I will update it here.
Hope it helps,
Community Support Team _ CaitlynIf this post helps then please consider Accept it as the solution to help the other members find it more quickly.
Hello, I have detected also an issue when I iuse icons in the conditional formatting, last week it exported as commented by Lawada with the name of the icon in a column but in the last days it crashes with the message "File couldn't be created. Executing the Query for the Export Data operation resulted in an error"
the export issue has been fixed . i can export my matrix now without having the conditional formating measure being exported within the the matrix
the export issue has been fixed . i can export my matrix now without having the conditional formating measure being exported within the the matrix
Hi lawada ,
Glad that your problem has been solved, please mark the correct reply as the standard answer to help the other members find it more quickly.Thanks in advance for your kind cooperation!
Hope it helps,
Community Support Team _ CaitlynIf this post helps then please consider Accept it as the solution to help the other members find it more quickly.
