Conditional color formating in a column chart with 2 measures

Anonymous You can try using

Expand the "Data colors" section.
You will see the measures listed under "Columns". Click on the fx button next to the measure you want to apply conditional formatting to.
In the "Default color" dialog that appears, choose "Field value" under "Format by".
Select the field that contains the conditional formatting logic. This field should return a color value based on your conditions.

If you have two measures, repeat the above steps for the second measure.
By setting up a field that returns color values based on your conditions, you can apply different colors to each measure in the chart. This approach allows you to handle multiple measures with conditional formatting in Power BI.

If you need to create a field that returns color values, you can use a DAX formula to define the logic. 

ColorMeasure =
SWITCH(
TRUE(),
[YourMeasure] > 500000, "Red",
[YourMeasure] > 100000, "Yellow",
"Green"
)
This DAX formula will return "Red" if the measure is greater than 500000, "Yellow" if it is greater than 100000, and "Green" otherwise. You can then use this field for conditional formatting.