Forum Discussion
Conditional formatting, 3 text options
Is there any way to set conditional formatting rules for a whole table based on text fields?
I have looked and can only create conditional formatting rules that are based off numbers. This is a snippet of the table. I would need yes values to be highlighted green, in transit light green, and no in Red.
Would i need to create a number column for each? If so, how would i do that?
Thanks!
Anonymous
Create the following measure, choose conditional formatting, Background , Select Field Value and choose this meaure:CF = VAR __V = MAX ( table[hardware assigned] ) RETURN SWITCH ( TRUE (), __V IN { "Yes", "In Transit" }, "Green", __V = "No", "Red" )
3 Replies
Hi Anonymous ,
Try like below:
step1,create a new measure:
Hardware = IF ( MAX ( 'Table'[Hardware Assigned] ) = "Yes", "#1E8449", IF ( MAX ( 'Table'[Hardware Assigned] ) = "In Transit", "#82E0AA", "#C70039" ) )Step2, Click the visual column,conditional formatting-Background color:
Step 3, configure like below:
Final get:
About color code ,refer this link :https://www.computerhope.com/htmcolor.htm
To learn more details ,refer:
Conditional Formatting with a Text Field in Power BI
Don't forget to give thumbs up and accept this as a solution if it helped you!!!
Best RegardsLucien
Anonymous
Create the following measure, choose conditional formatting, Background , Select Field Value and choose this meaure:CF = VAR __V = MAX ( table[hardware assigned] ) RETURN SWITCH ( TRUE (), __V IN { "Yes", "In Transit" }, "Green", __V = "No", "Red" )Thanks! It worked for me 🙂
