Forum Discussion

saadghojaria's avatar
saadghojaria
Frequent Visitor
2 years ago
Solved

Conditional formatting for bar chart percentage data

  I have data in percentage format and I want to create conditional formatting in such a way  100-95 : Green <96 - >=80 = Yellow <80 = Red I have kept formatting in point format 95% = 0.95 but s...
  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi saadghojaria ,

     

    According to your description, [total_in_time_dev_val] is a measure for which you want to create a conditional format, right?

    Then we can create a color measure.

    Color = SWITCH(TRUE(),
    [total_in_time_dev_val]<=1 && [total_in_time_dev_val]>=0.96,"green",
    [total_in_time_dev_val]<0.96 && [total_in_time_dev_val]>=0.8,"yellow",
    [total_in_time_dev_val]<0.8,"red")

    Setting the Conditional Format.

    Then the result is as follows.

    Best Regards,

    Neeko Tang

    If this post  helps, then please consider Accept it as the solution  to help the other members find it more quickly.