Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

To celebrate FabCon Vienna, we are offering 50% off select exams. Ends October 3rd. Request your discount now.

Reply
Anonymous
Not applicable

How do I export a Power BI table to Excel with colour formatting?

I have a table in Power BI where I've used Conditional formatting (colours) for ceratin values which a wish to export to Excel. How do I export the table to Excel and also keep the Conditional formatting in the export?

1 ACCEPTED SOLUTION
johncolley
Solution Sage
Solution Sage

Hi @Anonymous ,

 

Exporting to excel is currently only the data, not the formatting. There's an idea thread on it you can upvote: https://ideas.powerbi.com/ideas/idea/?ideaid=daac733c-ff89-44e1-b00e-957b9b862e6e 

View solution in original post

2 REPLIES 2
Anonymous
Not applicable

HI @Anonymous 

You can export the data as excel by clicking on the ellipses and making selection like below, however the formatting wouldn't be there

NikhilKumar_0-1655904849374.png

 

 

johncolley
Solution Sage
Solution Sage

Hi @Anonymous ,

 

Exporting to excel is currently only the data, not the formatting. There's an idea thread on it you can upvote: https://ideas.powerbi.com/ideas/idea/?ideaid=daac733c-ff89-44e1-b00e-957b9b862e6e 

Helpful resources

Announcements
September Power BI Update Carousel

Power BI Monthly Update - September 2025

Check out the September 2025 Power BI update to learn about new features.

August 2025 community update carousel

Fabric Community Update - August 2025

Find out what's new and trending in the Fabric community.

Top Solution Authors