Forum Discussion
How to Display Line Graph with all Months and Years
I have data across 4 years and want it to display in a line graph showing every month across every year but I can only get this to drill down to either:
January 2019, July 2019, January 2020, July 2020 and so on using the following Axis ordering and drilling down as far as possible within the chart
OR
December 2019, December 2020, December 2021 and so on using the following Axis ordering and drilling down as far as possible within the chart
I would like it to show October 2019, November 2019, December 2019, January 2020 and so on. It will do this in a bar graph, but not not the line.
I feel lik I am so close but not quite there. Can anyone please help?
LorenMcPherson on the formatting pane, change the x-axis type to categorical instead of continuous.
✨ Follow us on LinkedIn and to our YouTube channel
I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!
⚡ Visit us at https://perytus.com, your one-stop shop for Power BI-related projects/training/consultancy.
6 Replies
LorenMcPherson on the formatting pane, change the x-axis type to categorical instead of continuous.
✨ Follow us on LinkedIn and to our YouTube channel
I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!
⚡ Visit us at https://perytus.com, your one-stop shop for Power BI-related projects/training/consultancy.
Unfortunately I have already got it set as continuous and am still having issues
Oh, got it! Thank you very much. Sorry, I was looking at your image more than the text you had written. Perfect.
It is a matter of "sorting" your months and years date column. In data view, go to your date table > month & years column, at the top look for sort by column and sort your desired column into a sequential column.
Thank you. I had tried that also but unfortunately get the following which still doesn't detail everything I need.
LorenMcPherson it need to be categorical not continuous
✨ Follow us on LinkedIn and to our YouTube channel
I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!
⚡ Visit us at https://perytus.com, your one-stop shop for Power BI-related projects/training/consultancy.
