Forum Discussion
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.
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:
-
The export type chosen is "Summarized data", if you want to export a flat table,
or -
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
-
5 Replies
Hi PVVBl00
Please look into this video https://www.youtube.com/watch?v=2_zCCOVXTGEHi 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:
-
The export type chosen is "Summarized data", if you want to export a flat table,
or -
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
-
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 KumarHi 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
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
