Forum Discussion

prv_1401's avatar
prv_1401
Icon for Helper I rankHelper I
3 years ago
Solved

Conditional formatting for column chart is not working properly

Hi everyone,  I am facing an unusual issue in applying conditional formatting for column chart. I have attached below the images for your reference.   This is the column chart I have created  ...
Need Help
Show and Tell
Tips and Tricks
  • FreemanZ's avatar
    FreemanZ
    3 years ago

    hi prv_1401 

     

    0.13 is orange, because 0.13 > 0.26*20%

     

    in the conditional format rule setting, 100% is not 1, but 100% of the max value, which is 0.26 in your case. 

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Could you check the data type AND format of bLOCKEDI? Let me know if it's on Whole number and Percentage. Thanks!

prv_1401's avatar
prv_1401
Icon for Helper I rankHelper I
3 years ago

Its Decimal number and percentage