Action Analysis

The conditional formatting side panel provides options to customize the action dots and action colors. The options are similar to the color scale, data bars, and classification, which are explained here and here. The middle percentage option is used to set the desired median percentage value from which the spread is calculated.

The bubble size can be determined by comparing values in the same column or within the same row. You can also use a different measure to determine the size of the bubble.