Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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!
Solved! Go to Solution.
@liamcol
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" )
⭕ Subscribe and learn Power BI from these videos
⚪ Website ⚪ LinkedIn ⚪ PBI User Group
Hi @liamcol ,
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 Regards
Lucien
@liamcol
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" )
⭕ Subscribe and learn Power BI from these videos
⚪ Website ⚪ LinkedIn ⚪ PBI User Group
Thanks! It worked for me 🙂
User | Count |
---|---|
94 | |
86 | |
78 | |
70 | |
63 |
User | Count |
---|---|
114 | |
99 | |
97 | |
65 | |
59 |