Forum Discussion

chiran's avatar
chiran
New Member
2 years ago
Solved

Matrix table with colour rules

Hello Team,   I need to create a matrix table where it indicates the latest files received and if it has been transfered successfully in the database.   Here is my raw data:   Site Date Wo...
Need Help
Show and Tell
Tips and Tricks
  • Fowmy's avatar
    Fowmy
    2 years ago

    chiran 

    Create this measure:

    CF Color = 
VAR __CurrentDate = TODAY()
VAR __Date = SELECTEDVALUE( Table41[Date] )
VAR __Status = SELECTEDVALUE(Table41[Status])
VAR __Result = IF( __Date < __CurrentDate || __Status = "Error" , "red" , "green" )
RETURN
    __Result

    Select Status from the series drop down and click on fx

    Assign the mesure as Field Value

     




Fowmy's avatar
Fowmy
Super User
2 years ago

chiran 

Create this measure:

CF Color = 
VAR __CurrentDate = TODAY()
VAR __Date = SELECTEDVALUE( Table41[Date] )
VAR __Status = SELECTEDVALUE(Table41[Status])
VAR __Result = IF( __Date < __CurrentDate || __Status = "Error" , "red" , "green" )
RETURN
    __Result

Select Status from the series drop down and click on fx

Assign the mesure as Field Value