Hi

[mianjalil239]

Can I  conditional formatting option if I  put three different measures in chart ?

[rajendraongole1 · Accepted solution]

Hi @mianjalil239 - you can add it, but depends upon the chart that you are using, can you mention the chart name also

assumption like column/stacked bar charts, you can set different colors based on conditions for each measure in a stacked or clustered bar/column chart.

You can apply conditional formatting to the line colors, but it's based on the value of the measure or a rule you define in Line chart. 

basically ,If you want to use a single conditional formatting rule across all three measures, this can be more complex. Power BI generally requires you to set up conditional formatting separately for each measure.

Hope it helps

[ahadkarimi · Accepted solution]

Color Measure =
SWITCH( TRUE(),
[Measure1] > 1000, "#FF0000", -- Red for Measure 1 > 1000
[Measure2] > 500, "#00FF00", -- Green for Measure 2 > 500
[Measure3] > 300, "#0000FF", -- Blue for Measure 3 > 300
"#000000")

[mianjalil239]

Thanks Its already done by the help of @tharunkumarRTK

[rajendraongole1 · Accepted solution]

Hi @mianjalil239 - you can add it, but depends upon the chart that you are using, can you mention the chart name also

assumption like column/stacked bar charts, you can set different colors based on conditions for each measure in a stacked or clustered bar/column chart.

You can apply conditional formatting to the line colors, but it's based on the value of the measure or a rule you define in Line chart. 

basically ,If you want to use a single conditional formatting rule across all three measures, this can be more complex. Power BI generally requires you to set up conditional formatting separately for each measure.

Hope it helps