title: How to remove line coming start to end of graph in PowerBI line chart
body: <p>I'm relatively new to PowerBI,</p>
  
  <p>I build a report to show the evolution of different values over the last 30 days based on historic data I pull from an Excel file. Configuration-wise all my data is on the <em>Values</em> section of the line chart with the only exception of my <strong>Date</strong> field which is on the <em>Axis</em> section.</p>
  
  <p><a href="https://i.stack.imgur.com/iWCZg.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/iWCZg.png" alt="enter image description here"></a></p>
  
  <p>On the <em>FILTERS</em> section, I filtered the data to show only the last 30 days using the <em>relative date filtering</em>. This is basically the only filter I'm using. The issue is that the chart is showing a straight line from start to end of each one of the graph, and that for each data value...</p>
  
  <p><a href="https://i.stack.imgur.com/sSkmR.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/sSkmR.png" alt="enter image description here"></a> </p>
  
  <p>Can you please help me understand which might be the issue and how to solve it ?</p>
  
  <p>I think it might be related to the fact that my historic data is coming from an Excel Table that is being filled automatically over time, and importing the data into PowerBI makes lots of empty values on the table. I have tried filtering the data to exclude the empty values both on the table view and on the <em>FILTERS</em> section, but that has failed to solve the issue.</p>
  
  <p>EDIT (21.04.2020 - adding data)</p>
  
  <p><strong>PowerBI</strong> screenshot: beginning of data
  <a href="https://i.stack.imgur.com/b5IhQ.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/b5IhQ.png" alt="enter image description here"></a></p>
  
  <p><strong>PowerBI</strong> screenshot: end of data (239 rows - all distinct values)
  <a href="https://i.stack.imgur.com/2vhrU.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/2vhrU.png" alt="enter image description here"></a></p>
  
  <p>Y</p>