Forum Discussion

ringovski's avatar
ringovski
Helper II
4 years ago
Solved

Color Formatting

Hi All,

I am trying to format a % measure called "Learning Percentage Completed" with red when it's >50 and <75 then with orange when its greater than 75. I've created a new measure called "color measure" and have tried using a IF statement ( I need to additional conditions later on).

 

When I just return the number from the IF it returns the correct number;

Color Measure = 
     VAR _per = [Learning Percentage Completed]*100
     RETURN

     _per

 

But when I try comparing the numbers they are all orange when only 84.59 should be orange.

Color Measure = 
     VAR _per = [Learning Percentage Completed]*100
     RETURN

     IF(_per >50 && _per < 75, "Red","Orange")

 

This should be pretty simple but what am I missing?

 

Thanks

  • ringovski , This seems fine .

     

    Try this

     

    Color Measure = Switch( True() ,

    [Learning Percentage Completed] >.5 && [Learning Percentage Completed]  <.75, "Red",

    "Orange"

    )

     

     

    If this does not help
    Can you share a sample pbix after removing sensitive data.

2 Replies

  • ringovski , This seems fine .

     

    Try this

     

    Color Measure = Switch( True() ,

    [Learning Percentage Completed] >.5 && [Learning Percentage Completed]  <.75, "Red",

    "Orange"

    )

     

     

    If this does not help
    Can you share a sample pbix after removing sensitive data.

    • ringovski's avatar
      ringovski
      Helper II

      I got it by adding a third condition, as it is technically correct at the moment becuase it changing values below 50 as these aren't 50 to 75.

       

      Color Measure = 
           VAR _per = [Learning Percentage Completed]*100
           RETURN

           IF(_per >50 && _per < 75, "Red",

                 IF(_per > 75, "Orange",""))