Power BI Bar Chart Conditional Formatting Multiple Values

In this Power BI Tutorial, we will learn about how to change bar chart color based on the value in Power BI with a few examples, and also we will cover the below topics:

  • Power BI bar chart conditional formatting multiple values
  • Power BI bar chart conditional formatting highest values
  • Power BI bar chart conditional formatting between two values

Power BI bar chart color based on the value

Let us see how we can apply the bar chart color based on the value in Power BI.

In this example, we are going to use the below-mentioned Products ordered table data to display the stacked bar chart with sales value by the city in Power BI.

Power BI bar chart color based on the value example
Power BI bar chart color based on the value example
  • Open the Power Bi desktop and load data into it. Selected the stacked bar chart visual drag and drop the sales field and the city field value in the field section.
Power BI bar chart color based on the value
Power BI bar chart color based on the value
  • To apply conditional formatting for bars, select the Format Visual under the Visualisation pane, and Expand Bars -> Colors under the Visual tab (highlighted in Red):
  • Enable the background color and click on the Fx icon as shown below:
Example of Power BI bar chart color based on the value
Example of Power BI bar chart color based on the value
  • Now, Select the Format style as Rules and choose the column field value, Now add the rule that you want to apply. Select +New rule to add a new rule condition.
  • Add the condition to apply the conditional formatting for the sales column value.
  • Click on the Ok button to display the bar chart visual based on the condition applied.
Power BI bar chart color based on value
Power BI bar chart color based on the value

In the below screenshot, you can see that the bar chart displays the bar chart color changes the bar color based on the condition applied in conditional formatting.

Power BI bar chart color based on value example
Power BI bar chart color based on value example

This is how to apply the bar chart color based on the value in Power BI.

See also  This content isn't available. Learn more about Power BI [Solved]

Power BI bar chart conditional formatting multiple values

Here we will discuss whether it is possible to apply conditional formatting for multiple values in the stacked bar chart in Power BI.

  1. No, it is not possible to apply the conditional formatting for multiple values in the stacked bar chart and the stacked column chart in Power BI.
  2. We can only view the Fx icon to apply the conditional formatting for the bars and column charts with a Single field value.
  3. In Multiple field values, we cannot view the Fx icon option. In the following, we will clearly learn with examples.
  • Load source data into the Power Bi desktop. Selected the stacked bar chart visual from the visualization.
  • In the below screenshot, you can see that I have added two field values called Sales and Profit and displayed the bar chart.
Power BI bar chart conditional formatting multiple values
Power BI bar chart conditional formatting multiple values
  • To apply conditional formatting for bars, select Format Visual under the Visualisation pane, and Expand Bars -> Colors under the Visual tab.
  • Here you can see that there is no Fx icon presented for multiple values as shown below: We can change the color of the bars. But it is not possible to change the bar colors by applying conditional formatting for multiple fields.
Power BI bar chart conditional formatting multiple values
Power BI bar chart conditional formatting multiple values

It is not possible to apply conditional formatting for multiple values in the stacked bar chart in Power BI.

Power BI bar chart conditional formatting highest values

Let us see how we can see how to apply conditional formatting for the highest values for the bar charts in Power Bi.

See also  How to Use Power BI Weekday Function?

In this example, we will highlight the bar color for the highest value by applying conditional formatting in Power BI.

  • Load source data into the Power Bi desktop. Selected the stacked bar chart visual from the visualization. Drag-drop the sales field and city field into the field pane section.
  • Select the Format Visual under the Visualisation pane, Expand Bars -> Colors under the Visual tab and enable the background color and click on the Fx icon.
  • In the conditional formatting window, select the Format style as Gradient and choose the column field value, by default, lowest value, Middle value, and Highest Value as shown below:
Power BI bar chart conditional formatting highest values
Power BI bar chart conditional formatting highest values

In the below screenshot, we can see that based on the condition applied for the highest value it displays the bar chart.

Power BI bar chart conditional formatting highest values example
Power BI bar chart conditional formatting highest values example

This is how to see how to apply conditional formatting for the highest values for the bar charts in Power Bi.

Power BI bar chart conditional formatting between two values

Here we will how we apply conditional formatting between two values using the custom values in Power BI.

In this example, we will add two custom values to apply the conditional formatting in the stacked bar chart in Power BI.

  • Open the Power Bi desktop. Selected the stacked bar chart visual from the visualization. Drag-drop the sales field and city field into the field pane.
  • Select the Format Visual under the Visualisation pane, Expand Bars -> Colors under the Visual tab and enable the background color and click on the Fx icon.
Example of Power BI bar chart color based on the value
Example of Power BI bar chart color based on the value
  • Now, Select the Format style as Rules and choose the column field value, Now add the rule that you want to apply. Select +New rule to add a new rule condition.
  • Add the condition to apply the conditional formatting for the selected sales value column.
  • Click on the Ok button to display the bar chart visual based on the condition applied.
Power BI bar chart conditional formatting between two values
Power BI bar chart conditional formatting between two values

The Screenshot below displays the bar chart color based on the condition applied between two values.

Power BI bar chart conditional formatting between two values example
Power BI bar chart conditional formatting between two values example

This is how to do conditional formatting between two values using the custom values in Power BI.

See also  How to Calculate Percentage of Rows in Power BI

In this Power BI Tutorial, we have learned about how to change bar chart color based on the value in Power BI with a few examples, and also covered the below topics:

  • Power BI bar chart conditional formatting multiple values
  • Power BI bar chart conditional formatting highest values
  • Power BI bar chart conditional formatting between two values

You may like the following Power BI tutorials:

>