Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

custom limit lines using line graph

Hello, I have a set of data that if correct should present to form limit lines.  For example one  set might be:     y-axis             x-axis #amount      amount 15                  100 15     ...
  • v-jiascu-msft's avatar
    v-jiascu-msft
    7 years ago

    Hi Collin,

     

    So how can we or the graph know which dots should be connected and which dots shouldn't be connected?

    Maybe there is a workaround that adds a new column to group these dots. Please download the demo and give it a try.

    1. Create a column.

    Column = if([X] <= 600, 1, 2)

    custom-limit-lines-using-line-graph

    2. Add it to the legend.

    custom-limit-lines-using-line-graph2

     

    Best Regards,
    Dale

v-jiascu-msft's avatar
v-jiascu-msft
Microsoft Employee
7 years ago

Hi Collin,

 

So what's the result you expect?

 

 

Best Regards,
Dale

Anonymous's avatar
Anonymous
Not applicable
7 years ago

The x and y values line up with a units column, so if you had:

 

           y-axis             x-axis

units    #amount      amount

 1          15                  100

 1          15                  600

 2          30                  1,200

 2          30                  1,400

 

id like the legend to show the 1s and 2s not the Y vaules. 

 

Thanks for replying,     -Collin 

  • v-jiascu-msft's avatar
    v-jiascu-msft
    Microsoft Employee
    7 years ago

    Hi Collin,

     

    Just add the units into the legend. Is it?

    custom_limit_lines_using_line_graph2

     

    Best Regards,
    Dale

    • Anonymous's avatar
      Anonymous
      Not applicable
      7 years ago

      Hello dale, so this is what i have for data now . i would like to be able to have these dots connect  but not continuous .

      origonal - what i have

      what i want

      thanks,

      -Collin

       

       

       

      • v-jiascu-msft's avatar
        v-jiascu-msft
        Microsoft Employee
        7 years ago

        Hi Collin,

         

        So how can we or the graph know which dots should be connected and which dots shouldn't be connected?

        Maybe there is a workaround that adds a new column to group these dots. Please download the demo and give it a try.

        1. Create a column.

        Column = if([X] <= 600, 1, 2)

        custom-limit-lines-using-line-graph

        2. Add it to the legend.

        custom-limit-lines-using-line-graph2

         

        Best Regards,
        Dale