Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Ok, I promise I'll never understand conditional formatting in Power BI...
I want to format the rows of a table if column "Churn" is equal to "Label" like:
If it is: green
If it is not: red.
I tried all possible combinations with calculated measures, columns, etc, etc, etc, but nothing works.
Is it possible at all to do this?
Thank you!
Solved! Go to Solution.
Try to do the following, create a measure
"Color" =
VAR S_Value = SELECTEDVALUE(Table[Column])
RETURN IF(S_Value = "Label", "#00FF00", "#FF0000")
Then, select the column, go to Conditional Formatting > Background color > Field Value >Based on field: Select the measure "Color". That should do it.
Note: #00FF00 is HEX code for green, #FF0000 for red. You can customize this by opening a color palette and retrieving the HEX code.
@Anonymous
Thanks for your help!
Try to do the following, create a measure
"Color" =
VAR S_Value = SELECTEDVALUE(Table[Column])
RETURN IF(S_Value = "Label", "#00FF00", "#FF0000")
Then, select the column, go to Conditional Formatting > Background color > Field Value >Based on field: Select the measure "Color". That should do it.
Note: #00FF00 is HEX code for green, #FF0000 for red. You can customize this by opening a color palette and retrieving the HEX code.
User | Count |
---|---|
85 | |
77 | |
72 | |
70 | |
55 |
User | Count |
---|---|
106 | |
96 | |
90 | |
79 | |
68 |