title: PowerBI - Plot zero as values for missing rows in line charts
body: <p>I have a table where some of the rows(dates) are missing and I want to report zero for those in the chart. I am taking this table from some source and I cannot change that table to add missing dates.
  my table is something like this:</p>
  <pre><code>datetime | type | value
  25 Apr   |  A   |  2
  25 Apr   |  B   |  18
  26 Apr   |  A   |  2
  26 Apr   |  B   |  19
  27 Apr   |  A   |  2
  27 Apr   |  B   |  10
  28 Apr   |  B   |  29
  29 Apr   |  B   |  32
  30 Apr   |  B   |  33
  ...
  </code></pre>
  <p>plotting linechart and with 'type' as legend, the line for 'A' doesnot appear after 27 Apr while line for 'B' shows. somewhat similar to the image (example explained) below.</p>
  <p><strong>I want to show line for A also whereever lines are missing with zero values on the linechart</strong> without doing changes to my table. (in this case after 27Apr)</p>
  <p><strong>How do I do this in PowerBI reports?</strong></p>
  <p><a href="https://i.stack.imgur.com/Hc8El.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/Hc8El.png" alt="example" /></a></p>
  <p>Here, two lines are present B=darkblue &amp; A=lightblue. lightblue rows are missing after 27 Apr, so lightblue line doesnot show. <strong>I want to show the lightblue line throughout the chart with 0 values where rows are missing</strong>.</p>