power bi line chart - multiple lines single table

[jeffwash666]

Hi All,

My data looks like this.  I want to create a line chart where the Date is the X axis, the Amount is the Y axis, and each company has it's own line.  Can anyone help?

Company	Date	Amount
Company A	24-Jan	1366
Company A	24-Feb	1815
Company A	24-Mar	1974
Company A	24-Apr	1176
Company B	24-Jan	1413
Company B	24-Feb	1889
Company B	24-Mar	1405
Company B	24-Apr	1822
Company C	24-Jan	1889
Company C	24-Feb	1545
Company C	24-Mar	1775
Company C	24-Apr	1753

[mh2587 · Accepted solution]

 
> In the Visualizations pane on the right, click on the Line chart icon.
>In the Fields pane, drag the Date column to the Axis field.
>Drag the Amount column to the Values field.
>Drag the Company column to the Legend field.
 

[AnkitaaMishra · Accepted solution]

Yes you can have the different lines for each company by dragging "company" column on the legend field of the line chart as shown in the below snapshot : 

[mh2587 · Accepted solution]

 
> In the Visualizations pane on the right, click on the Line chart icon.
>In the Fields pane, drag the Date column to the Axis field.
>Drag the Amount column to the Values field.
>Drag the Company column to the Legend field.