Forum Discussion
Beginner needs help with a line chart
I am having a hard time understanding how to set up a line chart. I want it to be organized liike this: (the colors and font sizes, etc dont matter at this point)
The closest I've been able to come is this:
I've got the dates loaded as the axis and the values as so:
Can someone help this Power BI beginner out? I appreciate any help given.
Jeff
5 Replies
What is the structure of the table(s)?
This is an extract of the table.
Paul, below is a table containing data for the line chart. "WOT" is the week of training. So the dates are the 1st, 3rd and 5th week of training. I also changed some titles for better understanding. "1 WOT Run" are the 1 1/2 mile run times for the first week of training, "3 WOT Run" for the 3rd week of training and "5 WOT Run" for the 5th week of training. Thanks for helping me with this.
1 WOT PT Test 1 WOT Run 3 WOT PT Test 3 WOT Run 5 WOT PT Test 5 WOT Run 1-Dec-2021 14.27 17-Dec-2021 12.41 31-Dec-2021 12.49 1-Dec-2021 12.25 17-Dec-2021 12.01 31-Dec-2021 13.05 1-Dec-2021 10.07 17-Dec-2021 9.41 31-Dec-2021 10.13 1-Dec-2021 11.12 17-Dec-2021 10.46 31-Dec-2021 10.51 1-Dec-2021 12.03 17-Dec-2021 10.50 31-Dec-2021 11.45
Can you sopy and paste the data into a post? (can't work with images). Also we are going to need some help understanding what the WOTs are, and which values are you trying to plot against which dates....
