How do I sort the Month names in Slicer in chronological order

[vishu263]

Hello,

I am using a direct query and do not have the access to the data. Hence I cannot use 'sort by' other column to sort the months in chronological order. Is there any other way to get the months in chronological order inside the slicer.

Currently, I am getting the below sequence.

Thank you.

[Uzi2019 · Accepted solution]

Hi @vishu263 
You can add a new table (takes only 3 mins) by entering all months and month's no like this in power bi. Please follow the below steps:

As you can see my month is exactly as your's in desc order alphabetically.

Follow this relationship to connect your table with newly created table.

Then sort you Month's of newly created table according to Month's No.

Then take the month in slicer from newly created table{ Month , Month No}.

your new month is in proper sorting order.


If this solution helps you please give kudos and accept my solution!
Thanks!

[Uzi2019]

Hi @vishu263 ,
if you make you column as date data type then this should be auto sorting.

If my post helps you please give kudos and accept as a solution!

[vishu263]

Hi @Uzi2019 , 

I do not have the access to modify the data since I am working on a direct query. The datatype can be changed at Power BI Dataset level. Please see below.

Thanks.

[mickey64]

For your reference.

Step 1: I make a data file in Excel.

Step 2: I read the Excel File and add a relationship in Power BI Desktop.

Step 3: I change the order of 'Month' column by 'Order' column in 'Table view'.