Forum Discussion
Change date order in line chart
Hello everyone,
I have been working on a PowerBi dashboard with finctional sales data of pharma companies between 2017 and 2020 for a Uni Project. I have created already quite some visuals and working now on this line chart. As you can see, the dates are reversed (from left-to-right, recent-to-older), but i want to have it the other way around so 2020 appears on the right. The field I am using on the x-axis comes directly from an excel file is Month_year.
Any kind of help is appreciated!
Clckc the three dots [...] on the top right of the visual, then use the menu to change the sort sequnce
Learn how here
https://learn.microsoft.com/en-us/power-bi/consumer/end-user-change-sort
Please click the [accept solution] and thumbs up button. Thank you 😀
2 Replies
speedrampsSuper User
Clckc the three dots [...] on the top right of the visual, then use the menu to change the sort sequnce
Learn how here
https://learn.microsoft.com/en-us/power-bi/consumer/end-user-change-sort
Please click the [accept solution] and thumbs up button. Thank you 😀
Hi Anonymous
Normally, the dates on the x-axis of a line chart are sorted by default from older to recent. Check if your date column is being sorted using another column. If it is, you just need to change the order of the sorting column.Best Regards,
Jayleny
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.