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 

As we haven’t heard back from you, we wanted to kindly follow up to check if the suggestions  provided by the community members for the issue worked. Please feel free to contact us if you have any further questions.

 

Thanks and regards