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

Compete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.

Reply
PVVBl00
Helper III
Helper III

Extract conditional formatting

Good morning community,
I have the following question,
I have shared a BI model with a premium account. In the report, there are columns that have conditional formatting, and when extracting the information to Excel, the highlighted fields do not appear. Is there any way to make it work, or how should I do it?

I look forward to your responses, Have a good day

Pablo.

5 REPLIES 5
v-pgoloju
Community Support
Community Support

Hi @PVVBl00,

 

Just following up to see if the responses provided by community members were helpful in addressing the issue.

If one of the responses helped resolve your query, please consider marking it as the Accepted Solution. Feel free to reach out if you need any further clarification or assistance.

 

Best regards,
Prasanna Kumar

v-pgoloju
Community Support
Community Support

Hi @PVVBl00,

 

Just following up to see if the response provided was helpful in resolving your issue. Please feel free to let us know if you need any further assistance.

 

Best regards,

Prasanna Kumar

v-pgoloju
Community Support
Community Support

Hi @PVVBl00,

 

Thank you for reaching out to the Microsoft Fabric Forum Community, and special thanks to @Ritaf1983 and @PijushRoy  for prompt and helpful responses.

 

Just following up to see if the responses provided by community members were helpful in addressing the issue.

If one of the responses helped resolve your query, please consider marking it as the Accepted Solution. Feel free to reach out if you need any further clarification or assistance.

 

Best regards,
Prasanna Kumar

Ritaf1983
Super User
Super User

Hi @PVVBl00 

Conditional formatting does not carry over when exporting to Excel, unless you're using third-party visuals (paid), such as Inforiver.

However, the columns that have conditional formatting should still appear in the regular export.

Please make sure that:

  1. The export type chosen is "Summarized data", if you want to export a flat table,
    or

  2. If the export is using the "Current layout" option, all columns are visible (expanded) in the visual.

If everything mentioned above is correct and the columns still don’t appear, you can open a support ticket with Microsoft.

If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly

Regards,
Rita Fainshtein | Microsoft MVP
https://www.linkedin.com/in/rita-fainshtein/
Blog : https://www.madeiradata.com/profile/ritaf/profile
PijushRoy
Super User
Super User

Hi @PVVBl00 

Please look into this video https://www.youtube.com/watch?v=2_zCCOVXTGE 




Did I answer your question? Mark my post as a solution!
Appreciate your Like/Kudos

Proud to be a Super User!





Helpful resources

Announcements
August Power BI Update Carousel

Power BI Monthly Update - August 2025

Check out the August 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