Table heatmap same color

[Anonymous]

Hey all,

Im trying to set default color value, without a successes.

I have an hour column and a simple sum measure.

Sometimes the value is 0, which means that it's the the color should be the lightest, but if all the values are 0, it takes the darkest color:

sample data:

Hour	Cat1
08:00:00	0
09:00:00	0
10:00:00	0
11:00:00	0
12:00:00	0
13:00:00	0
14:00:00	0
15:00:00	0
16:00:00	0

if the values were different than 0 then the color was diverging. 

It should look like :

And the diverging is :

Any suggestions?

Thanks you!

[amitchandak]

@Anonymous , I think when the highest and lowest are equal the value will be considered as highest

[Anonymous · Accepted solution]

@amitchandak  Hey

I found a solution!

You need to check mark of the diverging. 

Then, the first color should be white, the second is your lightest color and adjust the value to 0. The third color is your darkest color.

works excellent !

[Anonymous]

@amitchandak  Hey

and there is no solution for that?