Reports, Speedometers, and Linear Gauge Widgets can use conditional coloring to show a performance color based on the coloring range you define. You can choose conditional coloring in Reports when editing column formatting.
For Speedometer and Linear Gauge widgets you can choose "Set Thresholds" when the data source is a Dataset or Initiative.
By default there are 6 conditional coloring segments, and all of the color thresholds are set to Auto.
For Speedometers and Linear gauges you'll need to choose a value for the lowest and highest thresholds. If you leave those blank for reports, however, they will find the highest value in the column and lowest value in the column, and then breaks up that range into 6 evenly sized segments. This results in a report that looks like this:
You can choose from a wide variety of color schemes. The options in the pink box are all smooth gradients that start in a light version of a color and end in a dark version of that color. The options in the blue box have a light color in the middle and have two different dark colors for high and low values. The two purple arrow options are gradients that hit different colors. One is a heat map gradient, and the other is a red/yellow/green scoring gradient.
You can also override any of the thresholds to be a specific value. This is helpful when you know acceptable ranges ahead of time. In this example we’ve changed the color scheme and we’ve increased the number of segments. We’ve also added thresholds so that anything with a value between $9k and $11k will be white. Anything above that will be increasingly darker shades of blue. Anything below will be increasingly darker shades of red.
The report now looks like this.
There’s a “Flip” button to flip the color order. In this example, higher values are now red and lower values are now blue.
This creates a report that looks like this.