Forum Discussion

LorenMcPherson's avatar
LorenMcPherson
New Member
4 years ago
Solved

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, Jul...
Need Help
  • parry2k's avatar
    parry2k
    4 years ago

    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.

     

parry2k's avatar
parry2k
Super User
4 years ago

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.

 

LorenMcPherson's avatar
LorenMcPherson
New Member
4 years ago

Oh, got it! Thank you very much. Sorry, I was looking at your image more than the text you had written. Perfect.