The Colorize function applies discrete colors to measures in the query, which is useful for displaying measures in different colors in grids and trellis charts. Enabling the Auto-Colorize function from the Design ribbon automates this process, by automatically 'colorizing' (copying to the Color zone) each measure added to the query.
If Auto-Colorize is enabled after the measures have been added, they will be colorized only when a change is made to the Values zone; for example, by adding or removing a measure.
In this example, Auto-Colorize was enabled (red arrow) after Sales, Cost, and Net Profit were added to the query, so the columns in the grid are not colorized.
But now, after Overhead was added to the query (red arrow), each column was automatically colorized (green highlight):
