Forum Discussion

Jessica_17's avatar
Jessica_17
Helper V
1 year ago
Solved

retaining matrix conditional formatting feature while exporting from power BI

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

  • 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.

1 Reply

  • 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.