Forum Discussion
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(...
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