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

amitchandak's avatar
amitchandak
Super User
5 years ago

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-numbers-in-the-column
https://docs.microsoft.com/en-us/power-bi/desktop-conditional-table-formatting#color-by-color-values

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.