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

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

Highlighted
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
Can You Solve These Challenge

Challenge: Can You Solve These?

Find out how to participate in the first Power BI 'Can You Solve These?' challenge.

New Badges

Incoming: New and Improved Badges

Exciting news: We've given our badges an overhaul and added brand news ones.

Ask Amir Anything

Exclusive LIVE Community Event No. 2 – Ask Amir Anything

Next in our Triple A series: Ask Amir Netz questions about the latest updates, features and future.

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: 358 members 3,362 guests