Forum Discussion
Months rolling on x-axis
Hello,
I am creating a trendline in PowerBI by using a date hierarcy on year, quarter, month. When selecting the month and having a filter on for instance 1-4-2019 to 31-3-2020, I would expect that the months are presented in this way (e.g. month most to the left is April, followed by May etc. ending on the right with March 2020). However, the graphs shows the calender year ordering (starting January ending with December). This makes it difficult to interpret the numbers correctly.
How do I change these settings?
FYI, the dataset is build on a live connection so I cannot adjust ordering with columns..
Hi Anonymous
If you click on "expand all level" below, it would sort as expected by the order "year-month".
Best Regards
Maggie
Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
2 Replies
- amitchandak
Super User
Anonymous
Check the sort column for month in this file -https://www.dropbox.com/s/wrcyk5j66corvjg/Apr2Mar-Cal.pbix?dl=0
This calendar for, FY Apr-Mar
v-juanli-msftCommunity Support
Hi Anonymous
If you click on "expand all level" below, it would sort as expected by the order "year-month".
Best Regards
Maggie
Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
