Forum Discussion
Custom overlays on line graph
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
1 Reply
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
