Forum Discussion
Solved
Conditional Formatting i
Hi all... trying to format the following in pbi and was unsuccessful. Yellow when value is > = -0.049 number Grey when < -0.049 and > = -0.099 number Red when < -0.099
Hi Tevon713 ,
This can be done in the condittional formatting pane depending on the visual you are using you should see a fx button on the color or if it's a matrix/table you should go to the cell elements.
Then just use the Rules on the panel it presents:
Something similar to this should work.
https://learn.microsoft.com/en-us/power-bi/create-reports/desktop-conditional-table-formatting
Select the visual
In Values → click the dropdown on the column → Conditional formatting
Choose Background color (or Font color)
Format by: Rules
Based on field: the same numeric field
Set rules in this exact order:
Rule Condition Value Color
| 1 | If value is greater than or equal to | -0.049 | Yellow |
| 2 | If value is less than -0.049 and greater than or equal to | -0.099 | Grey |
| 3 | If value is less than | -0.099 | Red |