Months rolling on x-axis

[Anonymous]

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.. 

[v-juanli-msft · Accepted solution]

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.

[amitchandak]

@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