Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Export Conditional Formatting to Excel?

Hi there,   I have a table with Conditional Formatting, basically it highlights the row(s) for records created in the last 10 days. But when I export to excel (either from the Power BI service or v...
Need Help
otravers's avatar
otravers
Community Champion
7 years ago

Anonymous A few options come to mind to address your requirement:

 

- Invite your partners/clients to a part of your SharePoint site and embed PBI there

 

- Export to PPT/PDF from the service

 

- Use Analyze in Excel to get the raw data in Excel, format your pivot with Excel conditional formatting, refresh and distribute. (This uses ODC behind the scenes.)

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    Thanks otravers 

     

    I'll check whether we are allowed to invite the partner to part of our SharePoint site. That might be the best option considering I've done all of the work in PowerBI to get the conditional formatting working already.

     

    Export to pdf unfortunately doesn't work - already tried that. It appears it just exports like a screenshot and the info has scrollbars so not all data shows on the pdf.

     

    Appreciate the ideas/options available to me.

     

    Thanks!