Forum Discussion

cocoloco79's avatar
cocoloco79
Helper III
5 years ago
Solved

Conditional Formatting based on Text Filed

Hi I need to colour format a text field that contains "NNNN" or "DDDD" or "OOOO" or "XXXX". Can someone please help me achieve this? Thank you in advance!!!  
Need Help
  • Anonymous's avatar
    Anonymous
    5 years ago

    Hi cocoloco79 ,

    Could you tell me if your problem has been solved?
    If it is, kindly Accept it as the solution. More people will benefit from it.
    Or you are still confused about it, please provide me with more details about your table and your problem or share me with your pbix file from your Onedrive for Business.


    Best Regards,
    Stephen Tao

cocoloco79's avatar
cocoloco79
Helper III
5 years ago

amitchandak 

Thank you and sorry I'm new to this all.

I have entered this formula but get an error.

Colour = if( CONTAINSSTRING('vdc_EmployeeLog'[Employee_Name],"NNNN" ) CONTAINSSTRING('vdc_EmployeeLog'[Employee_Name],"DDDD" ) CONTAINSSTRING('vdc_EmployeeLog'[Employee_Name],"OOOO" ) CONTAINSSTRING('vdc_EmployeeLog'[Employee_Name],"XXXX" ), "yellow", "white")
 
A single value for column 'Employee_Name' in table 'vdc_EmployeeLog' cannot be determined. This can happen when a measure formula refers to a column that contains many values without specifying an aggregation such as min, max, count, or sum to get a single result.
Thank you
Anonymous's avatar
Anonymous
Not applicable
5 years ago

Hi cocoloco79 ,

 

This is a similar post I answered before. Please kindly refer to:

 

Find if value contains anything from another column

 

If you are still confused about it, please provide me with more details about your table and your problem or share me with your pbix file from your Onedrive for Business.

 

 

Best Regards,

Stephen Tao

 

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