Forum Discussion
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
5 Replies
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 Color1 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 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
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
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.
