Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Solved! Go to 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,
Unpivot columns in Query Editor of Power BI Desktop as shown in the following screenshot.
Then create line chart as follows.
Regards,
Lydia
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
112 | |
97 | |
85 | |
67 | |
59 |
User | Count |
---|---|
150 | |
120 | |
100 | |
87 | |
68 |