title: Power BI Desktop Line Chart with Multiple Lines
body: <p>I'm trying to overlay three different columns in one chart on Power BI Desktop.</p>
  
  <p>To try to show a comparison of the number of orders per month by different years I have one column for Order Number, and three other columns for Sale Date; Sale Date 2016, Sale Date 2017 and Sale Date 2018. For each order number the three Sale Date columns have a number from 1-12 (representing the month in that year that the order occurred) or a null value (if the order occurred in another year). Something like this:</p>
  
  <p><img src="https://i.stack.imgur.com/vDU1v.png" alt="Example image"></p>
  
  <p>I'm trying to overlay the three Sale Date columns as individual lines on a line chart with Order Number (Count Distinct) as one axis and Sale Date 1-12 as the other axis. I would think that this would be comparatively simple but Power BI Desktop doesn't seem to have an option to set this up. I'd be open to other types of chart too, as long as the different years can be easily compared.</p>