cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Anonymous
Not applicable

Sorting problem per month

Hello,

I can not display the months in order from January -> December, it displays them in disorder. And the sort option is inactive.
I do not know how to solve this problem.

Thank you.

1 ACCEPTED SOLUTION

Accepted Solutions
Resolver IV
Resolver IV

Re: Sorting problem per month

Hello,

 

You have to create a new column that shows the month number in a year (Month function) and then sort your month name column by this new column. 

 

So, in your table create a new column MonthNo= Month('Calendar'[Date]) and then sort your column by this new column.

 

Regards,

ElenaN

 

 

View solution in original post

1 REPLY 1
Resolver IV
Resolver IV

Re: Sorting problem per month

Hello,

 

You have to create a new column that shows the month number in a year (Month function) and then sort your month name column by this new column. 

 

So, in your table create a new column MonthNo= Month('Calendar'[Date]) and then sort your column by this new column.

 

Regards,

ElenaN

 

 

View solution in original post

Helpful resources

Announcements
August 2020 Community Challenge: Can You Solve These?

August 2020 Community Challenge: Can You Solve These?

We're excited to announce our first cross-community 'Can You Solve These?' challenge!

July 2020 Community Highlights

July 2020 Community Highlights

Learn about the exciting things that happened in July.

Get Ready for Power BI Dev Camp

Get Ready for Power BI Dev Camp

We are thrilled to announce we will begin running a monthly webinar series named Power BI Dev Camp.

Power BI Desktop August 2020 Update

Power BI Desktop August 2020 Update

We have great updates this month! Click the link for the video with more info.

Top Solution Authors
Top Kudoed Authors