Highlight Widget Values with Color Coding

You can highlight content in a widget based on selections or results in other queries. For example, color code the values of number widgets based on thresholds to draw attention to low and high numbers.

Let’s say you want to change the colors of measures in three number widgets based on whether the numbers are high (green), medium (yellow), or low (red).

The number widgets show green, yellow, and red measures.

In the dashboard JSON, compute the color based on the measure of each query with a case statement. Then apply the computed color to the numberColor field of each number widget.