Creating bins from calculated column

Okay, I think I got it. Using this revised column for the Days Elapsed:

Days Elapsed (Deadline) = 
	SWITCH(
		TRUE(),
		Sheet1[CompleteByEndDate] < TODAY(), DATEDIFF(Sheet1[CompleteByEndDate], TODAY(), DAY),
		Sheet1[CompleteByEndDate] > TODAY(), -1 * DATEDIFF(TODAY(), Sheet1[CompleteByEndDate], DAY)
	)

I used this statement to make the bins and remove the Blanks (not late) in the Vis-level filter:

Bins = 
	SWITCH(
		TRUE(),
		Sheet1[Days Elapsed (Deadline)] >= 1 && Sheet1[Days Elapsed (Deadline)] <= 7, "A",
		Sheet1[Days Elapsed (Deadline)] >= 8 && Sheet1[Days Elapsed (Deadline)] <= 14, "B",
		Sheet1[Days Elapsed (Deadline)] >= 15 && Sheet1[Days Elapsed (Deadline)] <= 21, "C",
		Sheet1[Days Elapsed (Deadline)] > 22, "D"
	)