Colour Formatting

[New-here1]

Hi, 

How can I do the below please?

<10% shown in red

10%-90% shown in orange

>90% shown in green

Basically, I just want to show anything 0%-10% in red, anything between 10%-90% in orange and anything 90%-100% in red please

Thank you 

[SRA]

Hi,

I would say... the solution depends of what you really want.

If you have a table like this :

You can apply a "text color expression" on the measure of your table (or any measure/dimension you want to color) : If(Avg(Perc)<0.1, LightRed(), If(Avg(Perc)<=0.9, '#FF9900', Green()))

Remark :  '#FF9900' is an hexa color code for one orange... 

If you have a KPI like this : 

You can setup colors with limits... 

If none of these solutions fit to your requirement then tell us more about your requirement. 

If this is ok for you, please tick the answer as a solution.

Regards,

SRA