Conditional formatting for column chart is not working properly

[prv_1401]

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 

 And this is the rules I have given 

  

•  This is the outcome I get. But as per the rules wk 12 and wk13 shud be orange. Please enlighten me on this like why does this happen. 

  Thank you all .

  @amitchandak @Ashish_Mathur @FreemanZ please help

[prv_1401]

@FreemanZ  Thanks man. I am getting it .... so what is the alternative solution to resolve this ?

[FreemanZ]

hi @prv_1401 

you can choose number. the dividing point is up to your expectation. 

[prv_1401]

• No. I manually entered data in format like 0.05 so when I convert to percentage it is 5%. 
• 

   

So it's manually entered data.

[FreemanZ · Accepted solution]

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. 

[prv_1401]

When I keep the data type as whole number. The columns are not shown and when checked on data pane the values are changed to 0% for all weeks.

[Anonymous]

is bLOCKEDI a measure?

[Anonymous]

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

[prv_1401]

Its Decimal number and percentage

[Anonymous]

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 🙂