Help with creating line chart

[Patt]

Hi, I am relatively new to Powe BI and need tips and tricks on how to create what seems to be a simple line chart with the data below. I'd like to create (or plot lines for each job type by year e.g. 2010, 2011 and 2012. I'd like $'s on the y axis, and year on the x-axis and each line to represent the "job". I've entered the data as shown but can't seem to get the chart to show what i've just describe. the data seem to plot against one point the x-axis instead of move along the x-axis by year.

Thank you for your suggestions and tips.

[Anonymous · Accepted solution]

@Patt,

Unpivot columns in Query Editor of Power BI Desktop as shown in the following screenshot.


Then create line chart as follows.



Regards,
Lydia

[Patt]

@Anonymous Thank you!