retaining matrix conditional formatting feature while exporting from power BI

[Jessica_17]

Hello All,

I have a matrix table, which has conditional format applied for each column and rows values, Now the user's ask is that while exporting to excel or csv, the conditional format and matrix representation should stay intact, I am not sure how to acieve this, if there is any way with custom visual or even with power automate too, please let me know.

Thanks

[vicky_ · Accepted solution]

Unfortunately, neither option has the ability to preserve conditional formatting. I think your best bet would be to create a (VBA) script to format your exported data based on the same conditions as your original conditional formatting options.