Microsoft Power BI Cookbook

Create the visual

1. Open a Power BI Desktop report and create a clustered column chart visual with a measure and a dimension:
   • The measure will be added to the value field well and the dimension to the axis
2. Add a measure to the color saturation field well that will drive the color formatting of the value field.

3. From the formatting pane, open the data colors card and enter minimum and maximum values.
4. In the data colors formatting options, associate colors with these values, such as red with the minimum.

The color saturation field could be the same measure as the value field or a different measure that provides even further context. In this example, internet net sales is used as the value and internet sales var to plan is used for color ...