Conditional Formatting

[Tevon713]

Hi all... trying to set rules in pbi for a excel model conditional formating. Seem simple but I can't seem to get to work.

Yellow when value is >= -0.049 number

Grey when value  < -0.049 and >= -0.099 number

Red when value < -0.099

[Ray_Minds]

Solution :  Please try this

Ans will be Like below:

[cengizhanarslan]

1. Select the visual

2. In Values → click the dropdown on the column → Conditional formatting

3. Choose Background color (or Font color)

4. Format by: Rules

5. Based on field: the same numeric field

6. 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

[VijayP · Accepted solution]

@Tevon713 

Hope this helps

[Tevon713]

Thank you @VijayP and @cengizhanarslan  for your help.