title: How to get multiple category lines with bar chart in Power Bi?
body: <p>Sample Data.</p>
  <pre><code>CompanyA,2019-01-01,29000
  CompanyA,2019-02-01,35000
  CompanyA,2019-03-01,43000
  CompanyA,2019-04-01,27000
  CompanyA,2019-05-01,45000
  CompanyA,2019-06-01,21000
  CompanyA,2019-07-01,26000
  CompanyA,2019-08-01,27285
  CompanyA,2019-09-01,26035
  CompanyA,2019-10-01,24785
  </code></pre>
  <p><strong>Expected Output.</strong></p>
  <p>My Boss has asked me to show sale trend by companies and month. but he wants it to be shown like below.</p>
  <ol>
  <li><p>X axis should have Month Names</p>
  </li>
  <li><p>Bar lines should tell overall sales amount by month.</p>
  </li>
  <li><p>multiple lines should represent company sales amount.</p>
  </li>
  </ol>
  <p>i have achived this output by replacing 2 charts on each other (hidden one background). </p>
  <p><a href="https://i.stack.imgur.com/hlCpK.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/hlCpK.png" alt="Sample Image" /></a></p>
  <p>First i have taken a <strong>CLUSTERED COLUMN CHART</strong> and place a Line chart on it with hidden background.</p>
  <p><a href="https://1drv.ms/u/s!AvZUqpXgHxIVz2rV7sTPR1G8XQmn?e=wK3LXC" rel="nofollow noreferrer">Sample File</a></p>
  <p>But for me this is just an adhoc solution and One more problem is that both chart's y axis doesn't match.
  seeking for a good solution on this. either another good chart to represent this kind of data or how to achive it any other way?</p>
  <p>Thanks in advance.</p>