How to perform conditional formatting for clustered column chart

[bhavadharani]

Through formatting I need to change the color of the chart into green or red,

My need-

    1.In x-axis I have-LOS

           y-axis I have-Bench_Percent_co. If the bench_Percent is below 85 means then the chart should be viewed in red color otherwise             it should be in green color.

    I implemented it through rules in Default color-column 

but the color changes is not in a proper format

Here the Bench_percent_co is 63%  so it should be in red color  but the chart is in green color. Can you please help me to solve my problem. Thanks in advance

[Anonymous]

Hi @bhavadharani 

in your second statement after the "and" you have still the number argument, try changing it to percent like in the first argument 

Best Regards,

Daniel

[bhavadharani]

Thanks a lot @Anonymous 

  I changed the number argument as percent, Eventhough there is no changes. Can you please help me to solve the problem. Thanks in advance.

[Anonymous]

Is the Ouput of your measure formatted as percent? If not, use the decimal numbers (0,85 for 85% and 1 for 100%) and the number argument instead of percent

[bhavadharani]

Hi @Anonymous 

    It is a column which is formated as percent 

[bhavadharani · Accepted solution]

I checked all the ways to change the color in conditional formatting, after that I find out If I select to display only one bar chart then it always shows green color but when i didn't select anything it shows proper color(When I had group of charts). I think so it may be an issue.