Forum Discussion

mianjalil239's avatar
mianjalil239
Helper III
2 years ago
Solved

Hi

Can I  conditional formatting option if I  put three different measures in chart ?
  • rajendraongole1's avatar
    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

     

     

  • ahadkarimi's avatar
    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")