Custom overlays on line graph

Hi Anonymous,

Unfortunately the core charts don't have a way to provide reference lines along the category axis, like they do for the measure axis.

It is possible to leverage some features of the combo line/column chart and some DAX to do something more simple than what you're looking for - Parker Stevens has an excellent YouTube walkthrough on how you might set this up.

I have had a play with this a bit and have managed to tweak for an example I have lying around. Although these use dates, you might be able to re-purpose for your use case.

This is set up with a disconnected table for the date range, as per Parker's example, and I've added a parameter to manage the innner/outer threshold, and used conditional formatting to utilise the parameter and dynamically assign an inner/outer colour (whish are their own measures in the Banding Threshold table).

I've published this in the Data Stories Gallery so you can have a look and grab the sample workbook. Hopefully, this will give you something you can use as a stepping stone to get where you need to be.

Good luck!

Daniel