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

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

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

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel

Power BI Monthly Update - May 2024

Check out the May 2024 Power BI update to learn about new features.

LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.