Forum Discussion
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 come close to what i would want it to be in excel?
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
3 Replies
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
