High-Low Lines in Line Chart

[Anonymous]

Hi Guys,

Is there anyway to add High-Low Lines on a line chart?

I'm trying to recreate the following:

But struggling...having to effectively create 3 lines then edit the colours so it looks like a botched version of the above...

Any advice?

[Anonymous]

This is the best I've managed so far, it's a botched version with 3 line charts essentially.

Notice I have a few times where the numbers are flippe the wrong way round....any ideas on how I could fix it?

[pxg08680]

@Anonymous

May be I didn't get your question correctly, but if at all this is what you're looking for

[Anonymous]

Thanks for the quick reply. This isn't quite what I'm after, as this will just create a single line no?

I'm after the high-low for each week....

[v-jiascu-msft]

Hi @Anonymous,

What kind of data do you have? Maybe you can add two measures like this:

High =
MAX ( 'table'[Quantity] )

Best Regards,

Dale

[Anonymous]

So I have week start date for my X Axis, which is fine. I have an item, when it was InProgress and when it was Closed....so think I have all the data needed...just not sure how I could add the max/min lines...will give your advice a try 🙂