Conditional Formatting i

[Tevon713]

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

[v-sshirivolu]

Hi @Tevon713 ,
I would take a moment to thank @cengizhanarslan , for actively participating in the community forum and for the solutions you’ve been sharing in the community forum. Your contributions make a real difference.
 

I wanted to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions

[v-sshirivolu]

Hi @Tevon713 ,
I wanted to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions.

[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

[MFelix · Accepted solution]

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

[VijayP]

@Tevon713 

Hope this helps