title: Cumulative Line chart of date in powerbi
body: <p>In creating a PowerBI report for a ticketing system, I need to plot the cumulative lines for issues logged (this can be counted from Creation_Date) and issues resolved (this can be counted from Resolution_Date). How do I go about plotting these 2 lines?</p>
  
  <p>I read on the net, and <a href="https://community.powerbi.com/t5/Desktop/Cumulative-Line-Chart-Help/m-p/117040/highlight/true#M49392" rel="nofollow noreferrer">this thread</a> seemed relevant to what I want to do. But I did not understand how the solution works. </p>
  
  <blockquote>
    <p>Firstly, add an index column in your current table.</p>
  </blockquote>
  
  <p>When I add an index column, it just adds a sequence (1,2,3,4,...). I don't understand how that will be helpful.</p>
  
  <p>Can you help me with this line plotting?</p>
  
  <p>EDIT: I'm not sure, I can use the solution in above mentioned thread as is, because I don't have a numeric column like him. I will have to depend on a Measure to count the issues from Creation and Resolution date.</p>
  
  <p>EDIT 2: In response to @Foxan's answer, here is the screenshot of the sharp drop in the cumulative line</p>
  
  <p><a href="https://i.stack.imgur.com/BNaWj.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/BNaWj.png" alt="Sharp Drop in cumulative line"></a></p>
  
  <p><a href="https://i.stack.imgur.com/32EEk.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/32EEk.png" alt="Last few lines of the Creation Date Column"></a></p>
  
  <p>Even though the data mostly looks sorted, I can't assume it to be be sorted on Creation Date column. Could that be the problem?</p>