Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Plotting

I have two columns, Dates and NSR. However, when I try to plot them in a visual with Dates being the x-axis and NSR being the y-axis by dragging the NSR into values and Dates into axis, NSR automatic...
Need Help
  • Anonymous's avatar
    Anonymous
    7 years ago

    I found a solution - merged both tables together using an index column.

     

    Thank you.

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

Hi Anonymous

 

 

You may right-click the NSR value and choose 'Sum' or others as requested.

Regards,

Cherie

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    Hi Cherie, right now all the NSR values are summed as a value, and hence, when I plot my graph it's a straight line.

     



    As you can see from the graph below. I did the exact same thing for the graph above it and it plots the values nicely, so I'm not sure why this graph doesnt seem to work.

     

    The values are 1 for 1 - there are 27 values in the Dates column, and 27 values in the NSR column.

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

      Hi Anonymous

       

      It seems you use different tables' date column.There is no relationship between the two tables.You may use add the relationship for the two tables to get the visual.

      No relationship

      With relationship

      Regards,

      Cherie

      • Anonymous's avatar
        Anonymous
        Not applicable
        7 years ago

        Hi, I've already done so, but nothing is shown on the graph.