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 

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.

       

      • Anonymous's avatar
        Anonymous
        Not applicable
        6 years ago

        Hello Anonymous 

        I have it already on my vizualisation and added the field but i still do not get the colour formatting option.

         

        Kind regards,

        Ali