Conditional Formatting (Backround color) not shown when Export Data to Excel

[Tine82]

Hi PBI Experts 🙂

Question regarding Conditional Formatting (Backround color).
I made a Conditional Formatting (Backround color) in PBI Desktop . Now the user will Export the Data from PBI Online, but the Conditional Formatting is not shown in Excel.

I assume because the rule is only stored in PBI and no format is included in the export.

or is there a trick here ?

Thanks

Christine

[Kaviraj11 · Accepted solution]

You are correct in your assumption. When exporting data from Power BI to Excel, currently only the data is exported, not the formatting. This means that any conditional formatting rules applied within Power BI will not be transferred to ...