Forum Discussion

mariaLP1610's avatar
mariaLP1610
New Member
3 years ago
Solved

Calculated column conditional formatting

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.

Need Help
  • JoeBarry's avatar
    JoeBarry
    3 years ago

    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

2 Replies

  • JoeBarry's avatar
    JoeBarry
    Solution Sage
    3 years ago

    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