Traffic Light Conditional Formatting

[Jayfemi]

Hi i'm trying to get some conditional formatting to work in Bi i already know what the conditions will be but i'm not sure how i can get it working over in BI.

is there anythig that can come close to what i would want it to be in excel?

[MFelix]

Hi @Jayfemi,

You can add in the tables and matrix the conditional formating that will color the cell background within the defined values.

Regards,
MFelix

[Jayfemi]

Good Morning @MFelix,

I hope this finds you well, how would i go about doing that?

[MFelix · Accepted solution]

Hi @Jayfemi,

In the field context menu select the conditional formatting Color Scales then just add the definitions you need, be aware that this is a very simple conditional formatting (believe that will grow) but you can also use some distinct ways to make it work in intervals using measure or something like that.

Below see and example of one column with positive and negative numbers and other that I calculated with intervals of those to add an additional level of colour (interval between -5 and 5).

Regards,

MFelix