Forum Discussion
Helper IConditional Formatting (Backround color) not shown when Export Data to Excel
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
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 the Excel file
1 Reply
- Kaviraj11
Solution Sage
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 the Excel file