take over colored Excel

To change color based on value, select a visualization to make it active. Open the Formatting pane by selecting the paint roller icon and then open the Data color card. Hover over the card, and select the three vertical dots that appear and choose Conditional formatting.

select the conditional formatting option by clicking the three vertical dots

In the Default color pane, use the dropdowns to identify the fields to use for conditional formatting. In this example, we've selected the Sales fact > Total Units field and selected light blue for the Lowest value and dark blue for the Highest Value.

settings for conditional formatting by data color

column chart with default colors applied

You can also format the color of the visual using a field that is not part of the visual. In the following image, %Market Share SPLY YTD is being used.

As you can see, although we've sold more units of both Productivity and Extreme (their columns are higher), Moderation has a larger %Market Share SPLY YTD (its column has more color saturation).