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!

Anonymous's avatar
Anonymous
Not applicable
3 years ago

p.s you can check this by clicking on the column in the right hand side "fields" pane then look at the top ribbon in "Column tools". 

 

It should tell you both the format and data type there 🙂