Forum Discussion

manojk_pbi's avatar
manojk_pbi
Helper V
1 year ago
Solved

Power BI Export to Excel

Hello    I have table chart with colod coding, delta change indicators etc, how can we export this table as in to excel. I don't see any options to export with all color coding. One i tried is expo...
Interesting Links
Need Help
Show and Tell
Tips and Tricks
  • v-nmadadi-msft's avatar
    v-nmadadi-msft
    1 year ago

    Hi manojk_pbi ,
    Thanks for reaching out to the Microsoft fabric community forum.

    You can use Analyze in Excel, which lets you connect Excel pivot tables directly to your Power BI dataset. While this approach won’t automatically bring over Power BI’s conditional formatting, you can easily recreate the same rules using Excel’s built-in conditional formatting features.

     


    Another option is to use Power BI paginated reports and creating visualizations with it,
    and they can be exported to Excel with all formatting preserved.

     

     

     

    I hope this information helps. Please do let us know if you have any further queries.
    Thank you


v-nmadadi-msft's avatar
v-nmadadi-msft
Community Support
1 year ago

Hi manojk_pbi 

I wanted to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions.


Thank you.