Power BI Conditional Text Formatting Made Easy

what if the text contains a certain word, and I want to give a number based on what the text contains, and not based on an single value?

let's suppose I have 2 measures and concatenate in one calculation so I want to give it distinct colors in both fields. Is it possible to power bi?

This is awesome. Can we apply conditional formatting on a perticular cell, not on entire column?

I want a particular cell without build in the conditional formatting, can I do that?

Thank you for This!! Solved a major problem

Thanl you! It was helpful tip.

can we bold rows ?

Very helpful. Thank you

Hi
.in summarization option..not showing average option...only showing counts option even after make calculated column with number...pls solve this

Thanks for the video! I wonder if this will work with other columns

Thank you so much! I had spent lots of time on this issue, then come across your video. voila, you helped me!

It works! Thanks <3

I did it as you have shown but my background is still not changing from color. That is so weird.
Is it because i am using values from 2 different excelsheets in my PowerBI?

very helpful! thanks so much!

This was helpful thank you!

Hi, how can I do a wild card e.g. instead of looking for the word vacant, I want anything that starts with "vac" to highlight, so I can highlight words like vaccine vacation, etc. I tried contains and I tried switch, any help will be appreciated, thanks

The text I am trying to "switch" are the words TRUE and FALSE. I keep getting this error - Function 'SWITCH' does not support comparing values of type True/False with values of type Text. Consider using the VALUE or FORMAT function to convert one of the values.

How would we do this with a measure isnstead of column?

Great video! I liked the way you showed the problem of trying to set up the formatting without the extra number column; this is exactly the process I went through! One question - if I want to format the whole row, is there a quick way of doing this or do I have to set up the formatting rules for each field one at a time.

Saving lives!!! Thanks!

thank you

Thanks, clear explanation

Your video is super helpful. I was able to color format my field based on your instruction.

Thank you!

perfect video, it exactly does what i wanted to do. Would data load slowly if i created a column in powerquery editor instead of just there in dax?

Thanks brother for this video helped me a lot ❤️

finally, was looking for this exactly!!

Thanks a lot!!!!

Very Easy! Thank you!

Great video man! Thanks so much for posting this! 👍

I wasn't aware of the "Switch" function but it's very simple to use and effective. Thanks for being awareness to it!

how would you do this but using a measure instead of a column?

hi, Really good video. How can i conditional formatting on dates? For example if the date in Power PowerBI has expired it goes red

How to highlight entire row?

How to make entire row?

Your explanation made it so simple to keep putting food on my table. Thanks!!

Great Vid thanks

Great tip. thanks a lot

Great video. It was very helpful. Thank you. What about a scenario where the values are not the same. For example, a value may be Exampl*2, Example*3, and you need this value to have the same color.

Thank you for this idea that is working well when we have a define number of texts to describe but I was wondering if you have another tips for text begining by Z*** to put in red or if if the text is blank/empty, then put it in red too. Thanks

Worked great. Thank you.

How to apply this colour formatting,based on a column's text to its corresponding values of different columns

Wow, i can't believe this is the only way

All going well until conditional formatting doesnt show as an option when I try for a row

Good work around for this issue. Thank you so much for sharing 👍

You save my life brother, Thanks!!!

Eric!!, thanks a lot my friend, I was searching for this solutions for many hours, your explanation and solution is so Simple and Friendly, that I cant believe why I didn't figure out before...thanks a lot "super data brothers" you have saved me :)

Man, you have 5k views but this video just saved me a ton of time. Was doing a POC that involved creating some dummy stuff in Power BI. Great job & easy explanation. Cheers & have a grand day.

Can I copy conditional formatting settings to another field?

thank you sooooooooooo much this was exactly what I was looking for :D