Calculated column conditional formatting

[mariaLP1610]

Hello!

i am trying to change the font color of values in a table based on a condition.

I have a table that has a column named 'SubmitDate'

I have created a calculated column using the following

Days Since Submission = DATEDIFF(myRequests[SubmitDate],Now(),DAY).

This is the column i use in the table visual.

When this number is greater than 5 i want the font to be Red.

I tried selecting the column and add conditional formating using a rule. I am getting the count but i dont want a summarization. 

I also get an error.

I also tried to create a measure that simulates the logic, for example

MeasureName = IF([YourColumnName] > 5, 1, 0)

 if value is 1 then color is red. 

I cannot seem to be able to select the column.

Any help will be appreciated.

[JoeBarry · Accepted solution]

Hi @mariaLP1610 

Instead of Count of Days Since Submission, try Max. Also in the second part of the criteria, you need to add a number larger than 5 and not < 0 as in your screenshot

Thanks

Joe

[Addyy]

Thanks for this information