You can try using the "Temperature Diverging" color palette and reverse it. It'll be red - yellow - green, instead of gold, but it'll color in everything dynamically.
The other way to get exactly the colors you want is to change the measure values pill on your colors shelf from continuous to discrete. This will cause every numerical value to have its own color. Then you can manually give each number the color you'd like. Obviously there's a lot more work involved in doing it this way.
1 of 1 people found this helpful
Can you try below code.
IF [Column name] > 80% THEN 'Green'
ELSEIF [Column name] > 65 AND [Column name] <= 80 THEN 'Gold'
ELSEIF [Column name] < =65 THEN 'Red'
Drag this calculated filed in color .
I don't think the "Temperature Diverging" will work because the color coding needs to be set to particular numbers...but if I can assign each number a color like in your second idea, that might work! It'd be time consuming but would only need to be done once I would assume. Do you know I would do that?
Unfortunately, the columns are just the ways I have the data organized (like a filter). I have measure names in the rows and measure values in the text shelf so it shows the measure value (ATTR) within the table. If I'm misinterpreting your response though, let me know!