How can a color condition be applied in a column chart in Power BI with upper and lower limits?

edit

To apply a color condition with upper and lower limits in a column chart in Power BI, follow these steps:

1. Select the column chart you want to modify.

2. Click on the Data view and add a new column to your dataset that reflects the color condition you want to apply. For example, if you want to color a column green if the value is above 80, red if it's below 60, and yellow if it's between 60 and 80, create a column with the following formula:

   =IF(value > 80, "green", IF(value < 60, "red", "yellow"))

3. Go back to the Visualizations tab and select the column chart.

4. Click on the three dots (...) next to the Values section of the Visualizations pane, and select "Conditional formatting".
5. In the "Based on field" dropdown menu, select the column you created in step 2.
6. Under "Color scale", select "Custom diverging".
7. Set the minimum and maximum values to 0 and 100, respectively.
8. Set the colors for the minimum, mid, and maximum values. For example, you could set the minimum value to red, the mid value to yellow, and the maximum value to green.
9. Adjust any other settings you want, such as the legend, and click "OK".

Your column chart will now show the colors you specified based on the values in the column you created. Values above 80 will be green, values below 60 will be red, and values between 60 and 80 will be yellow.