Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago

High-Low Lines in Line Chart

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?

 

 

Need Help

5 Replies

  • pxg08680's avatar
    pxg08680
    Icon for Resolver III rankResolver III
    8 years ago

    Anonymous

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

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      8 years ago

      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's avatar
        v-jiascu-msft
        Icon for Microsoft Employee rankMicrosoft Employee
        8 years ago

        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's avatar
    Anonymous
    Not applicable
    8 years ago

     

    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?