Conditional Formatting based on Text Filed

[cocoloco79]

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!!!

 

[v-stephen-msft · Accepted solution]

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

[amitchandak]

@cocoloco79 , In matrix you will not be able to color row or column, But can color values.

Create a color meausre like -if( CONTAINSSTRING('Table'[field],"NNNN" ) || CONTAINSSTRING('Table'[field],"DDDD" ) || CONTAINSSTRING('Table'[field],"OOOO" ) || CONTAINSSTRING('Table'[field],"XXXX" )
, "yellow", "white")

And then use in coditional formatting with "Field Value" Option

https://radacad.com/dax-and-conditional-formatting-better-together-find-the-biggest-and-smallest-num...
https://docs.microsoft.com/en-us/power-bi/desktop-conditional-table-formatting#color-by-color-values

[cocoloco79]

@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

[v-stephen-msft]

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.