Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Grow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.

Reply
cocoloco79
Helper II
Helper II

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

 Capture5.PNG

1 ACCEPTED SOLUTION
v-stephen-msft
Community Support
Community Support

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

View solution in original post

4 REPLIES 4
v-stephen-msft
Community Support
Community Support

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
Super User
Super User

@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

@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

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.

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel

Power BI Monthly Update - May 2024

Check out the May 2024 Power BI update to learn about new features.