Sorting month name descending in order

[RashmitaR]

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

[v-haibl-msft · Accepted solution]

@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] )

Best Regards,

Herbert

[RashmitaR]

Hi @v-haibl-msft

I tried your solution.It is working .Thanks

[v-haibl-msft]

@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

[Anonymous]

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

[BhaveshPatel]

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