

If the same data is used in a different visualization, none of the conditional formatting rules will apply. One of the drawbacks of using either the Color scale format or Rules format is that any changes made in the advanced editor are specific to that visualization. Users can add additional rules to create complicated conditional formatting scenarios and assign specific colors for values that meet the criteria for each rule. This option uses standard If/Then conditional rules to specify what color should be applied to a cell when the rule applies to the value. The second advanced option for conditional formatting is to use Rules instead of the Color scale to determine the formatting: The colors selected for minimum and maximum values can be changed to generate a different color scale, and the values used to generate the scale can be changed to eliminate outliers or to adjust for scale. There are a lot of options in the Color scale formatting that can be modified by the report creator. If we click on the Advanced controls link for the Font color option, it shows the default (Color scale) which generates a color for each cell based on the color scale generated from the lowest and highest values in the column. Power BI will automatically apply color formatting to the value, and the range of colors will be automatically calculated based on the range of values in the column. Let’s apply Font color Conditional formatting to the Revenue column.

After selecting one of the columns, the user can then choose from applying conditional formatting to the Background color, Font color, or adding Data bars:Ĭlicking on the slider for any one or more of the Conditional formatting options will apply it to the visualization. When you have a visualization selected that supports conditional formatting the option will be available to you in the formatting pane:Įxpanding the Conditional formatting option will show the list of numeric columns that can have conditional formatting applied. First, make sure the visualization is actively selected in Power BI Desktop. If you have a table of data and would like to apply conditional formatting to a numeric column, you can choose between three different formatting options. Conditional Formatting using Power BI formatting pane
