Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Conditional formatting for Text Fields

Hi there,   I have a matrix which brings in Overall Status Assessment that is a text field that contains Red, Amber & Green. I would like to do conditional formatting which uses icons however it se...
Need Help
  • Anonymous's avatar
    Anonymous
    3 years ago

    Hi Arul,

     

    Thanks, I got it to work. Just Power BI not playing nice, so instead of copying & pasting in the measure formula that you provided, I re-wrote it manually which then invokes the auto-populate feature for functions and it worked.

     

    Thanks

    Darren

     

  • lukiz84's avatar
    lukiz84
    3 years ago

    can you mark my measure as solution, thx

lukiz84's avatar
lukiz84
Memorable Member
3 years ago

Hi,

 

try 

 

NumbersMeasure = 
   VAR rowValue = SELECTEDVALUE(Work[Overall Status Assessment])
   RETURN SWITCH(
      TRUE(),
      rowValue = "Red", 1,
      rowValue = "Amber", 2,
      rowValue = "Green", 3,
      -1
    )