cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
RashmitaR Member
Member

Sorting month name descending in order

Hi I am usinga a Matrix where in i have year and month name in my columns.Could someone please suggest a way to display the month name in descending order (i.e september,august,july,june,etc.)

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
v-haibl-msft Super Contributor
Super Contributor

Re: Sorting month name descending in order

@RashmitaR

 

You can create a MonthNum column with following formula. Then select the Month column and make it sorted by MonthNum column.

MonthNum = 
- MONTH ( Table1[Date] )

Sorting month name descending in order_1.jpgSorting month name descending in order_2.jpg

 

Best Regards,

Herbert

View solution in original post

5 REPLIES 5
BhaveshPatel Super Contributor
Super Contributor

Re: Sorting month name descending in order

Hi There,

 

Please follow this blog post for more information.

It is Straight Forward and Requires little tricks.

 

https://community.powerbi.com/t5/Desktop/Sorting-by-Month-as-Text-Jan-Feb-Mar-etc/td-p/9237\

 

Thanks & Regards,

Bhavesh

Thanks & Regards,
Bhavesh

Love the Self Service BI.
Please use the 'Mark as answer' link to mark a post that answers your question. If you find a reply helpful, please remember to give Kudos.
krajani Member
Member

Re: Sorting month name descending in order

Within Query Editor, you can create a conditional column and assign a numeric value to the column based on months. In Power BI, in the Data View, you can use the 'Sort by Column' feature to sort the month column based on values of the (conditional) column you created in Query Editor.

 

Thanks

Kaz

Highlighted
v-haibl-msft Super Contributor
Super Contributor

Re: Sorting month name descending in order

@RashmitaR

 

You can create a MonthNum column with following formula. Then select the Month column and make it sorted by MonthNum column.

MonthNum = 
- MONTH ( Table1[Date] )

Sorting month name descending in order_1.jpgSorting month name descending in order_2.jpg

 

Best Regards,

Herbert

View solution in original post

RashmitaR Member
Member

Re: Sorting month name descending in order

Hi @v-haibl-msft

 

I tried your solution.It is working .Thanks

v-haibl-msft Super Contributor
Super Contributor

Re: Sorting month name descending in order

@RashmitaR

 

In my last screenshot of matrix report, the Month names are in descending order like Sep, Aug, July, June in 2016.

What is your expected result?

 

Best Regards,

Herbert

Helpful resources

Announcements
Ask Amanda Anything Q&A

Ask Amanda Anything Q&A

Learn the answers to some of the questions asked during the Amanda Triple A event.

October 2019 Community Highlights

October 2019 Community Highlights

October was a busy month in the community. Read the recap article to learn about some of the events and content.

New Solution Badges

New Solution Badges

Two waves of brand new solution badges are coming! Read the article for more information on our new community badges.

Analytics in Azure virtual event

Analytics in Azure virtual event

Experience a limitless analytics service built to ingest, prep, manage, and serve data for immediate use in Power BI.

Users Online
Currently online: 196 members 2,653 guests
Please welcome our newest community members: