How can i do conditional formatting on column which has text as well as numbers.

[Anonymous]

Hi PowerBi Community,

I have columns which consists of num,text,% how can i change their background colour either by using conditionalformat/Manually changing Background colour for each field,

Please refer Attached Documents:

PowerBi Pagei want to make like this

Thanks in advance. 

[Anonymous]

Please Help Me Anyone !!!

i am reallly stucked in my work.

Thanks in Advance

[v-chuncz-msft]

@Anonymous 

You may simply try Color formatting by field value.

[Anonymous]

Hi @v-chuncz-msft ,

Thank you ! but this columns have text,num,%

I have tried it before ,please refer to the attached output what i am getting:This is my requirement

[Anonymous]

some more Screen shots for reference:(Not a sensitive data)power bi pageneed to make like this