Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
soniasweety
Master
Master

Colour based on value

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?

1 Solution

Accepted Solutions
sunny_talwar

Check with this

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

View solution in original post

22 Replies
sunny_talwar

May be like this

ARGB(Expression * 25, 192, 192, 192)

soniasweety
Master
Master
Author

sorry sunny wrong input

its dimension   I calculated in backend and I am calling that as a dimension.

above not working for dimension

sunny_talwar

May be this

ARGB(Dimension* 25, 192, 192, 192)

soniasweety
Master
Master
Author

tried in measure also its not working

check below

argb.PNG

soniasweety
Master
Master
Author

still not working

same result which I attached below image for both dim,measure aswell

sunny_talwar

This is a color, right? Also, What is the values for Open Date?

its_anandrjs

Can you provide small sample for this.

its_anandrjs

You can try this expression in your Background Properties of your chart.

soniasweety
Master
Master
Author

Hi Anand& sunny

PFA.  first sheet    ,time left to breach sla column values should be colored by value   light color to dark.