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?

22 Replies
soniasweety
Master
Master
Author

Attached sample sunny.  you can see the data

soniasweety
Master
Master
Author

yes anand its working but I need  light colur to dark based on values 

like  if it is   1  means light color  if it is 2 means it will give more than first color,  like that

sunny_talwar

Which tab?

soniasweety
Master
Master
Author

first tab only.

straight table ,time left column

its_anandrjs

OK then write this in expression

=ARGB( YourDimension * 25, 128, 128, 128)

soniasweety
Master
Master
Author

still same colour it is showing for all values,

sunny_talwar

Where are you specifying the color? or you don't know where to do this?

soniasweety
Master
Master
Author

I applied in Bg of dimension and tried .

tried to add as a measure and applied still not worked.

can you suggest where to apply?

sunny_talwar

Check attached, the grey is getting darker as you move down on the chart... is this what you wanted?

soniasweety
Master
Master
Author

yes sunny,

but I want  light red to dark red only?     I tried red  value but its not working

how can I get the red colur as Bg?