Keep formatting on Excel Export

[Q&A Bot]

Q:  When exporting a table or pivot table, the cell and value colors should be preserved. Is that possible?

Yes, it is possible to have the same colors formatting in a report web view, PDF and Excel exports.

To achieve that you need to use in the Expression-type dimension (or measure) these functions for colors formatting (instead of Html.Raw):

• Html.SetTextColor to set the color of the text (applied to cell's tag TH/TD).
• Html.SetBackgroundColor to set background color of the text (applied to cell's tag TH/TD).

(see also: https://www.seektable.com/help/report-html-formatting)