Timeline visualization - weeks with or without a value

Hi ReadTheIron ,

You'd need to convert your failures into a number in order to apply them as format conditions.

You could use a measure something like this:

_failureFlag =
IF(
  NOT ISBLANK(yourFailureTable[failureDate]),
  1,
  0
)

Then put this measure into the matrix with your calendar dates as columns.

In the conditional formatting options for the matrix, you would apply formatting as RULES, then set the rules based on this measure to 'value is 1' = RED, 'value is 0 = GREEN'.

Pete

Hi ReadTheIron ,

I have built a simply data samply as shown below:

Based on my test, I'd suggest you create a new calendar table and build relationship between it and Failure table like this:

Calendar = ADDCOLUMNS( CALENDAR(DATE(2021,1,1),MAX('Repaired Table'[Date Repaired])) ,"Week",WEEKNUM([Date],2))

Then create a flag measure to specify which week is fail based on each asset:

Flag = COUNT('Failure Table'[Date Failed])+0

Create a matrix visual and apply conditional formatting for both background and font:

Turn on Vertical grid and Horizontal grid ,The final output is shown below:

Best Regards,
Eyelyn Qin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.