Colour based on value

[soniasweety]

Hi all,

I have a straight table  with one measure  that result is like below

1

2

3

4

5

6

7

8

9    like that  I need to give this bg colour   light to dark         how can I give?

[sunny_talwar · Accepted solution]

Check with this

=ARGB((MAX(TOTAL TimeLefttoBreachSLA) - Min(TOTAL TimeLefttoBreachSLA))/255 * TimeLefttoBreachSLA, 255, 0, 0)

[soniasweety]

Yes sunny its working   could you please explain how it is working  ?

[brunobertels]

Hi

Argb() has 4 values to define color .

First value give transparency , the others give RGB colors.

So Sunny use a mesure in the ARGB function to define transparency depending of a range between the max and min mesure of TimeLefttoBreachSLA divided by 255

I didn't know this method so Thanks Sunny

Bruno