How can I apply conditional formatting to a bar chart in Power BI?

By /

Conditional formatting is a useful feature in Power BI that allows users to visually highlight specific data points in a bar chart based on certain conditions. To apply this formatting to a bar chart in Power BI, users can first select the desired chart and then access the “Format” tab. From there, they can choose the “Conditional formatting” option and set the conditions and formatting rules they want to apply. This will enable the bar chart to automatically change its appearance based on the specified conditions, making it easier for users to identify important data points and trends.

Power BI: Apply Conditional Formatting to Bar Chart

Often you may want to apply conditional formatting to a bar chart in Power BI so that bars with a value greater than a specific number have one color while bars with a value less than the number have another color:

Power BI conditional formatting for bar chart

Fortunately this is easy to do and the following example shows how to do so.

Example: Apply Conditional Formatting to Bar Chart in Power BI

Suppose we have the following dataset in Power BI that contains information about various basketball players:

Suppose that we would like to create a bar chart to visualize the sum of points scored by each team.

To do so, click the Report View icon on the left hand side:

Then click the icon called Line and stacked column chart under the Visualizations tab.

Then choose Team for the X-axis and Points for the Column y-axis:

This will create the following bar chart that displays the sum of points scored by players on each team:

Now suppose that we would like to apply conditional formatting to the bars such that the bars with a value of 100 or greater are blue and the bars with a value less than 100 are red.

To do so, click the Format your visual icon, then click the dropdown arrow next to Columns, then click the Conditional Formatting (fx) icon:

  • Format style: Gradient
  • What field should we base this on: Points
  • Minimum: Custom value of 99 with a red color
  • Maximum: Custom value of 100 with a blue color

Once you click OK, conditional formatting will be applied such that the bars with a value of 100 or greater are blue and the bars with a value less than 100 are red:

Power BI conditional formatting for bar chart

We have now successfully applied conditional formatting to the bar chart based on the numerical values of the bars.

Additional Resources

The following tutorials explain how to perform other common tasks in Power BI:

Power BI: How to Apply Conditional Formatting to Text Column

x

Related terms:

  1. How can Conditional Formatting be Applied to a Bar Chart in Power BI?
  2. How do I apply conditional formatting to a text column in Power BI?
  3. How can I apply conditional formatting to a text column in Power BI?
  4. How can I apply conditional formatting to Yes/No values in Google Sheets?
  5. Excel: Apply Conditional Formatting to Second Highest Value
  6. Excel: Apply Conditional Formatting to Yes/No Values
  7. Excel: Apply Conditional Formatting to Dates Older Than 1 Year
  8. Student asks: How do I apply conditional formatting to duplicate values?
  9. How to apply conditional formatting if two cells are not equal
  10. How to Apply Conditional Formatting if Between Two Values