Exporting unicode symbol does not include color

[pkn7]

Hi,

When trying to export a matrix which has a column that displays either red or green color circle based on unicode. it was working fine. but today when i tried to export color is not getting exported. any help on this how to get the color also while exporting

Regards,

Priyanga

[v-karpurapud]

Hi @pkn7 

I hope this information is helpful. Please let me know if you have any further questions or if you'd like to discuss this further. If this answers your question, please Accept it as a solution and give it a 'Kudos' so others can find it easily.

Thank you.

[v-karpurapud]

Hi @pkn7 
Hope you are doing well!

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. If my response has addressed your query, please accept it as a solution and give a 'Kudos' so other members can easily find it.

Thank you.

[v-karpurapud]

Hi @pkn7 

May I ask if you have resolved this issue? If so, please mark the helpful reply and accept it as the solution. This will be helpful for other community members who have similar problems to solve it faster.

Thank you.

[v-karpurapud]

Hi @pkn7 

Thanks for reaching out to Microsoft Fabric Community Forum.

I agree with the solution provided by @suparnababu8 .

Additionally:

1. Export as PDF or Image Format: If retaining color formatting is essential, consider exporting your matrix as a PDF or saving the visual as an image instead of using CSV or Excel formats.
2. Use Conditional Formatting in Excel After Export:Once the data is exported to Excel, you can manually apply conditional formatting to recreate the color coding.

If you find this post helpful, please mark it as an "Accept as Solution" and give a KUDOS.
Thank You.

[suparnababu8 · Accepted solution]

Hi @pkn7 

Unfortunately, Power BI's native export functionality often doesn't preserve conditional formatting, including colors, when exporting to csv/excel. 

You can try a work around using, Power BI Tiles add-in for Excel, which allows you to embed Power BI visuals directly into Excel. This might help retain the formatting. How to add Power BI tiles in excel, Please refere this https://learn.microsoft.com/en-us/power-bi/create-reports/service-dashboard-tiles and https://learn.microsoft.com/en-us/power-bi/create-reports/service-dashboard-pin-tile-from-excel 

Thanks