Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
Anonymous
Not applicable

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

1 ACCEPTED SOLUTION
v-juanli-msft
Community Support
Community Support

Hi @Anonymous 

If you click on "expand all level" below, it would sort as expected by the order "year-month".

Capture10.JPG

Capture11.JPG

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.

View solution in original post

2 REPLIES 2
v-juanli-msft
Community Support
Community Support

Hi @Anonymous 

If you click on "expand all level" below, it would sort as expected by the order "year-month".

Capture10.JPG

Capture11.JPG

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
Super User
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

Share with Power BI Enthusiasts: Full Power BI Video (20 Hours) YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube

Helpful resources

Announcements
July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.

Join our Fabric User Panel

Join our Fabric User Panel

This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.

June 2025 community update carousel

Fabric Community Update - June 2025

Find out what's new and trending in the Fabric community.