Treemap Colors

Question & Answer
, , , ,
1

Hi!!

I am using a treemap I and want to set the color range manually from 0 to 1. At the moment what the chart is doing is getting the minimum value of the field and set is as red and the maximum as green, I need 0 to be red and 1 to be green and not depending on the filtered values.

Is there a way to do that?

Thanks

2

Hello Victor,

Have you tried to use the format visuals as shown below for the tree map chart ?

image
image256×666 27 KB

Hope this helps.

Cheers,
Deep

3

Hi, Thanks for the answer but that’s only to change the colors. What I want to change is the range of the values of those colors, so I set red to 0 and green to 1, not to the maximum and minimum of the actual values of the table. Hope I made it a bit clearer now.

4

Hi @victord ,

If your intent is to get two solid colors into the heatmap cells, you should set the colors in the property panel as @Deep showed above. Then, create a calculated field that evaluates to 1 or 0, bring that to color field well and set the aggregate on it to min.

I’m marking this as solution for now. Please let us know if you have further questions.

Regards,
Arun Santhosh
Pr QuickSight SA