Forum Discussion
Creating a line graph
Good afternoon,
Thanks for your help on my last question. I now have another that has probably already been asked and answered but I can't seem to find it. I have a single row of data I am trying to put in a line chart where the X-axis is in months and the y axis is in values. How do I build my visual (line graph)? When I try the points are like a scatterplot in one row or none at all.
in pq you can create a new column
= if [2025] = "January" then 1
else if [2025] = "February" then 2
else if [2025] = "March" then 3
else if [2025] = "April" then 4
else if [2025] = "May" then 5
else if [2025] = "June" then 6
else if [2025] = "July" then 7
else if [2025] = "August" then 8
else if [2025] = "September" then 9
else if [2025] = "October" then 10
else if [2025] = "November" then 11
else if [2025] = "December" then 12
else nullthen make sure the new column's data type is whole number and sort 2025 by the new column
at last sort by the 2025 column
pls see the attachment below
5 Replies
Wait! I think I'm close. I just need to figure out how to get the months in the correct order. They are listed in order on the uploaded data.