exporting matrix visual to excel keeping the same format

[lawada]

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:

[v-xiaoyan-msft]

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 _ Caitlyn

If this post helps then please consider Accept it as the solution to help the other members find it more quickly.

[v-xiaoyan-msft]

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 _ Caitlyn

If this post helps then please consider Accept it as the solution to help the other members find it more quickly.

[lawada]

the export issue has been fixed . i can export my matrix now without having the conditional formating measure being exported within the the matrix

[lawada]

the export issue has been fixed . i can export my matrix now without having the conditional formating measure being exported within the the matrix

[PedroIDI]

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"

[AlexisOlson · Accepted solution]

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