Color Diverging by Thresholds?
I have a 5 column table with 4/5 being measures. Each column has their own threshold and are different measures so I can't simply write a calculated field to compute the colors. I have to color by measure values. I'm looking for help to solve one of the columns so that if understand it I can apply the same kind of thinking to the other columns.
For one of my measures, I have this requirement. Green: $156,000 Yellow: 100-156K Red: 0-100K
I've set it up as Temperature Diverging, 3 stepped color with red and green, reversed checked, full color range checked. What do I need to put for my Start, End, and Center values to meet those threshold colors above?