Forum Discussion

inglexjc's avatar
inglexjc
Post Patron
3 years ago
Solved

Getting certain text to show in Red

I'm wanting the text (Letter Waived) to show in RED.   I've gone to the Column name Description and went to Conditional formating and choose font color.   But all options have to do w...
Need Help
  • Anonymous's avatar
    Anonymous
    3 years ago

    Hi inglexjc 

    You can use CONTAINSSTRING() function

    e.g 

     

    Measure 4 = IF(CONTAINSSTRING(SELECTEDVALUE('Table'[Description]),"Letter Waived"),"red","white")

     

     

     

    Then put it to the conditional formatting

    Output

     

    Please refer to the following link to know more about  CONTAINSSTRING() function:

    CONTAINSSTRING function (DAX) - DAX | Microsoft Learn

     

    Best Regards!

    Yolo Zhu

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

     

     

     

     

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Hi inglexjc 

You can use CONTAINSSTRING() function

e.g 

 

Measure 4 = IF(CONTAINSSTRING(SELECTEDVALUE('Table'[Description]),"Letter Waived"),"red","white")

 

 

 

Then put it to the conditional formatting

Output

 

Please refer to the following link to know more about  CONTAINSSTRING() function:

CONTAINSSTRING function (DAX) - DAX | Microsoft Learn

 

Best Regards!

Yolo Zhu

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