Forum Discussion

PVVBl00's avatar
PVVBl00
Helper III
1 year ago
Solved

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 in...
  • Ritaf1983's avatar
    1 year ago

    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