Gantt chat: Color code issue

[RENJITH_R_S]

Hello friends,

I have created a calculated column using unichar codes and added to resource field of microsoft gantt chart. I am getting correct output in Power Bi desktop but the same report i am looking from power bi service, i m not getting correct colors. all colors r showing in gray and black. please help on this

[v-jingzhang]

Hi @RENJITH_R_S 

Here is an update

=========================================

It's a known bug in Chromium engine (Chrome, Edge browsers) 1266022 - Emoji rendering lost color in Chrome 96 - chromium

It should be fixed in the following versions of the browser.

The Desktop App uses not the latest version of the Chromium engine, so it works fine for now.

Best regards,

Jing

[RENJITH_R_S · Accepted solution]

@v-jingzhang , Thanks

[v-jingzhang]

Hi @RENJITH_R_S 

Can you share the unichar codes of these squares? Which version of Power BI Desktop do you use?

I could reproduce this issue and my result is a little different from yours. I tested some unichar codes of colorful squares in Desktop 2.99.621.0 64-bit (November 2021) and put them in resource field of microsoft gantt chart. They displayed in black and grey in my Desktop as well as in the service.

You could try some custom gantt charts as an alternative currently. I added this column to Data label field of Gantt Chart by MAQ Software and it shows the colors correctly. 

Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.

[RENJITH_R_S]

@v-jingzhang , I worked with the MAQ Gantt Chart able to resolve the color issue, but in this there is no sort option available, I need 2 visuals based on sort of 2 columns , 1 visual will sort by start data and 1 will sort by prgram, please let me know your comments

[RENJITH_R_S]

@v-jingzhang , for me color is showing in desktop & in service is not showing. this issue raised after november update. I m using microsoft gantt chart visual

see me code

Final Status Health =

SWITCH(

TRUE(),

_P_WP_DeliverablesAndMilestones[Final Status]="Late Milestone",CONCATENATE(UNICHAR(128997),_P_WP_DeliverablesAndMilestones[Data label]),

_P_WP_DeliverablesAndMilestones[Final Status]="On Track Milestone", CONCATENATE(UNICHAR(129001),_P_WP_DeliverablesAndMilestones[Data label]),

_P_WP_DeliverablesAndMilestones[Final Status]="Completed Milestone", CONCATENATE(UNICHAR(128998),_P_WP_DeliverablesAndMilestones[Data label]),

_P_WP_DeliverablesAndMilestones[Final Status]="Late Deliverable",CONCATENATE(UNICHAR(128308),_P_WP_DeliverablesAndMilestones[Data label]),

_P_WP_DeliverablesAndMilestones[Final Status]="On Track Deliverable", CONCATENATE(UNICHAR(128994),_P_WP_DeliverablesAndMilestones[Data label]),

_P_WP_DeliverablesAndMilestones[Final Status]="Completed Deliverable", CONCATENATE(UNICHAR(128309),_P_WP_DeliverablesAndMilestones[Data label]))

[v-jingzhang]

Thank you. I will report this issue and update here if I get any news. 

Best regards,

Jing