Forum Discussion
Hi
Can I conditional formatting option if I put three different measures in chart ?
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
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")
3 Replies
- rajendraongole1Super User
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
- ahadkarimiSolution Specialist
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")- mianjalil239Helper III
Thanks Its already done by the help of tharunkumarRTK