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 me...
Need Help
Need Help DAX
  • amitchandak's avatar
    amitchandak
    4 years ago

    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.

amitchandak's avatar
amitchandak
Super User
4 years ago

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
    4 years ago

    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",""))