Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Colour formatting on Measure

Heya everyone!   Ive got another query, in my report I have a measure which states that if a text contains "true" it will display active and if its false it will display "closed".   Status = IF(...
Need Help
Show and Tell
  • Anonymous's avatar
    Anonymous
    6 years ago

    Anonymous Please create a measure for color formatting

    Color = IF(MAX('Table'[Status])="Closed","#ff0000","#66ff33")

    Right click on status measure

    Select conditional formatting >> Background color

    Select format by field value

    In based on field select Color measure created above

    click oK 

Tahreem24's avatar
Tahreem24
Super User
6 years ago

Hi Anonymous ,

 

You can create a masure like below with up and down arrow to show you status:

 

Icon = SWITCH([Status],"Closed",UNICHAR(129095),"Active",UNICHAR(129093))
 
Please give THUMBS UP for support and mark it as a solution if it helps you!