Forum Discussion

Patt's avatar
Patt
Frequent Visitor
8 years ago
Solved

Help with creating line chart

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's avatar
    Anonymous
    8 years ago

    Patt,

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


    Then create line chart as follows.



    Regards,
    Lydia

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable

    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's avatar
      Patt
      Frequent Visitor

      Anonymous Thank you!