Can't get my conditional formatting to work

[rpinxt]

I have this simple matrix :

Now I want to do something with the hours above 20.

Hours in the field you can put conditional formatting on but somehow I cannot find a field to use in this box :

I would think the field would be hours because that is the field I want collored base on its value....

[Kishore_KVN]

Hello @rpinxt  in this case you should not choose Field Value. You have to choose Rules option and then provide the conditions on Hours column then it will fulfil your requirement. 

If this post helps, then please consider accepting it as the solution to help other members find it more quickly. Thank You!!

[rpinxt]

Thanks @Kishore_KVN but unfortunately not:

Still cannot choose the field Hours in here.

[Kishore_KVN]

Hello @rpinxt What is the data type of the hour column check it first. It has to be a number and then select it here in the rules. Also you have to select number in both the places instead of percentage and number then only it will start reflecting. 

If this post helps, then please consider accepting it as the solution to help other members find it more quickly. Thank You!!

[rpinxt]

Well @Kishore_KVN  it is a time format :

It reflects hours between 2 timestamps so it cannot be just a number.

If I set it to number than the field makes no sense anymore.

This calculated field is the result of 2 day/time fields subtracted.

[Kishore_KVN · Accepted solution]

Understood @rpinxt , create one new column which will have only hours from this time column with the help of below syntax: 

New Column = HOUR('Material Document'[Hours])
Then use this new column for the conditional formatting rules based. 

If this post helps, then please consider accepting it as the solution to help other members find it more quickly. Thank You!!

[rpinxt]

Thanks @Kishore_KVN this did the trick.

Made a new measure like you said and used that field (which is number format) for the conditional formatting.

Works great.