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(MAX('table'[column]) = "True","Closed","Active")

I also wanted to add colour formatting to this in my quick measure. After some research I heard that colour formatting is not a option within DAX but I wanted to confirm

 

IF its not possible, Could I possible make a measure to display a green "active" if true else display a "red" closed by using two different text boxes?

 

Any help is appreciated.

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 

6 Replies

  • 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! 

     

     

  • Anonymous's avatar
    Anonymous
    Not applicable
    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 

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      Hey Vimal,

       

      I cannot seem to find the conditional formatting option when I right click on status measure:

       

       

       

      Kind regards,

      Ali

      • Anonymous's avatar
        Anonymous
        Not applicable
        6 years ago

        Add that measure in to a table visual and right click on the measure name under visualizations. Please refer the scrrenshot for the same.