Conditional formatting in Bar Chart

[Bilal_Niazi123]

Hi,
I have a stacked bar chart where I want to apply conditional formatting. The y-axis is 'Job Name' and the x-axis has all numeric columns that are showing the number of days. I want to apply conditional formatting of these number of days columns.
For example, if 'opened - sent' <12 then the bar color should be green otherwise red.
If 'Sent - 1st interview' < 5 then green otherwise red.
If '1st - 2nd interview' < 5 then green otherwise red and so on...
Kindly check the attached image to get a clear picture of my requirements. Any help/suggestion will be appreciated.
Thank You

[TomMartens]

Hey @Bilal_Niazi123 ,

you can not achieve what you are looking for, because currently the default visuals are not supporting conditional formatting when multiple values are used in the bucket list or when a categorical variable is used in bucket list.

Next to that, there will be a problem with the legend (even if you do not show the legend), how do you imagine  a legend when one jobname is green and one jobname is red?

You can only achieve what you are looking for by using Deneb: https://deneb-viz.github.io/

Hopefully, this provides some insights to get you started.

Regards,

Tom

[Bilal_Niazi123]

Hi @TomMartens , 
Thanks for your response. Unfortunately, the Deneb bar chart is not allowing me to use more than one field on a column. Is it possible with hard code? 
Help please if you think it is the only solution of my requirements. 
Thanks