Colour Formatting

New-here1 — Tue, 22 Apr 2025 11:41:51 GMT

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

Re: Colour Formatting

SRA — Tue, 22 Apr 2025 15:03:57 GMT

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

topic Colour Formatting in App Development

Colour Formatting

Re: Colour Formatting