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

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
Anonymous
Not applicable

Conditional formatting on a Text filed

Hi all: Good day! I am trying to do conditional formatting on a text field- ‘Priority’ on my ‘Table’ visual. I have selected “don’t summarize” on that field. Priority can have text values like ‘crirical, ‘no-ciritical’, ‘planned-service’, etc. I want to show them in colors like critical-red, non-critical-blue, etc. As I select background color/ font color for conditional formatting on ‘Priority’, it shows Count of Priority in  ‘Based on field’. As a result of this, I cannot enter custom values for min/max/.. as non-critical, critical, etc. It only let me enter numerical vals like 1, 2, … How do I format fields that are ‘text’?

Any help is much appreciated! 🙂

 

sohananahid_0-1594939519426.png

 

 

1 ACCEPTED SOLUTION
parry2k
Super User
Super User

@Anonymous create a measure for color then use that in conditional formatting

 

Color Measure = 
SWITCH ( MAX ( Table[Priorty] ), 
"Critical", "Red",
"Non-Critical", "Blue"
)

 

I would  Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos whoever helped to solve your problem. It is a token of appreciation!

Visit us at https://perytus.com, your one-stop shop for Power BI related projects/training/consultancy.



Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!

Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo

If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤


Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.

View solution in original post

3 REPLIES 3
amitchandak
Super User
Super User

@Anonymous , Just create a measure as suggested by @parry2k .

For steps refer: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

Share with Power BI Enthusiasts: Full Power BI Video (20 Hours) YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube
parry2k
Super User
Super User

@Anonymous create a measure for color then use that in conditional formatting

 

Color Measure = 
SWITCH ( MAX ( Table[Priorty] ), 
"Critical", "Red",
"Non-Critical", "Blue"
)

 

I would  Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos whoever helped to solve your problem. It is a token of appreciation!

Visit us at https://perytus.com, your one-stop shop for Power BI related projects/training/consultancy.



Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!

Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo

If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤


Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.

Anonymous
Not applicable

Thanks @parry2k for the solution!

For other newbees like me, I added "black" for other cases and Format  by 'field value' during Conditonal formatting on the field "Priority" as below:

 

Color Measure =

SWITCH ( MAX ('Table xyz' [Priority]),

"critical", "red",

"non_critical", "green",

"planned_service_outage", "cyan",

"black")

Then on field-> Priority-> Conditional formatting-> font color->

sohananahid_0-1594995517495.png

 

 

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

Find out what's new and trending in the Fabric community.

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.

Top Solution Authors