Forum Discussion
Hi
- 2 years ago
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
- 2 years ago
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")
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")
Thanks Its already done by the help of tharunkumarRTK