https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Conditional-Formatting-Backround-color-not-shown-when-Export/m-p/3958223#M153606 <P><SPAN>You are correct in your assumption. When exporting data from Power BI to Excel, currently only the data is exported, not the formatting.&nbsp;</SPAN><A href="https://community.fabric.microsoft.com/t5/Desktop/How-do-I-export-a-Power-BI-table-to-Excel-with-colour-formatting/td-p/2595031" target="_blank" rel="noopener">This means that any conditional formatting rules applied within Power BI will not be transferred to the Excel file</A></P><P>&nbsp;</P> Wed, 29 May 2024 13:44:46 GMT Kaviraj11 2024-05-29T13:44:46Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Conditional-Formatting-Backround-color-not-shown-when-Export/m-p/3958109#M153602 <P><SPAN>Hi PBI Experts <span class="lia-unicode-emoji" title=":slightly_smiling_face:">🙂</span><BR /><BR />Question regarding&nbsp;Conditional Formatting (Backround color).<BR />I made a&nbsp;Conditional Formatting (Backround color) in PBI Desktop . Now the user will Export the Data </SPAN>from<SPAN> PBI Online, but the&nbsp;Conditional Formatting is not shown in Excel.<BR /><BR /></SPAN></P><P><SPAN>I assume because the rule is only stored in PBI and no format is included in the export</SPAN>.</P><P>or is there a trick here ?</P><P>Thanks</P><P>Christine</P> Wed, 29 May 2024 12:53:25 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Conditional-Formatting-Backround-color-not-shown-when-Export/m-p/3958109#M153602 Tine82 2024-05-29T12:53:25Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Conditional-Formatting-Backround-color-not-shown-when-Export/m-p/3958223#M153606 <P><SPAN>You are correct in your assumption. When exporting data from Power BI to Excel, currently only the data is exported, not the formatting.&nbsp;</SPAN><A href="https://community.fabric.microsoft.com/t5/Desktop/How-do-I-export-a-Power-BI-table-to-Excel-with-colour-formatting/td-p/2595031" target="_blank" rel="noopener">This means that any conditional formatting rules applied within Power BI will not be transferred to the Excel file</A></P><P>&nbsp;</P> Wed, 29 May 2024 13:44:46 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Conditional-Formatting-Backround-color-not-shown-when-Export/m-p/3958223#M153606 Kaviraj11 2024-05-29T13:44:46Z