How can I add thresholds for my time in board column chart?

[nbrown02]

I want to set some guidance for statuses in my time in board column chart. How do I do this?

[nbrown02]

There are a few ways you could do this. Here's a few examples:

Adding a constant line

If I wanted to just set a constant line, you'd select the chart. Go to the analytics pane and add a line:

Highlighting when any column goes above a specific value

Go to the format visual pane, click on the formula button and set a threshold for the TimeInColumnDays measure. For example here anything above 20 days goes red:
​

Highlighting when a specific column(s) goes above a specific value

Say this is your data:

And you wanted to highlight when In Progress > 15 or when In Review > 10, you'd add a new measure:

StatusFormatting = 
VAR InProgressThreshold = 15
VAR InReviewThreshold = 10

VAR CurrentStatus = SELECTEDVALUE('WorkItems History2'[To]) 
VAR Duration = SUM('WorkItems History2'[Dur])

RETURN 
    SWITCH(
        TRUE(),
        CurrentStatus = "In Progress" && Duration > InProgressThreshold, 1,  -- Highlight "In Progress" if > 15 days
        CurrentStatus = "In Review" && Duration > InReviewThreshold, 1,  -- Highlight "In Review" if > 10 days
        0  -- Default (no highlight)
    )

Then in your chart formatting, you'd do the following:

And your chart would update: