Custom overlays on line graph

[Anonymous]

Good afternoon all,

New user here, trying to find my way around PowerBI by taking on a project to build a tool for work. 

My usage is a little unique, possibly, utilising the tool to handle and analyse large volumes of traffic data.

I have a line graph with 2 values input; speed (kph) and flow (vehicles per minute). 

What I now need to do, is come up with a method of creating a vertical colour overlay, or band, on the graph. I also require for these values to be user-editable, so, for example, I can set a green bar to appear when the flow value exceeds "x" - I have mocked up something similar to what I require below:

Does anyone have any idea whether what I am attempting to do is possible? 

Thanks in advance. 

Tom

[dm-p]

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