Forum Discussion

Jayfemi's avatar
Jayfemi
Helper I
9 years ago
Solved

Traffic Light Conditional Formatting

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 ...
  • MFelix's avatar
    MFelix
    9 years ago

    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