Date Hierarchy is not in order

[Anonymous]

Dear Experts

I have 2 different reports which uses this below date hierarchy.

One of the report is showing the date on the slicer in order as FYear,  FQuarter, FMonth and FWeek.

But in the other report the FMonth is showing in the alphabetical order.

Please can someone suggest how to bring the May next to April.

Thanks

Mahad

[Anonymous · Accepted solution]

Hi @Anonymous ,

You need to add a new column to help you sort the month.

Please try below steps:
1. my test table

Month:

2. add a "Index" column in Power Query

3. sort "Month" column by "Index" column

4. in the table visual ,you can see the "Month" sort by index

Please refer the attached .pbix file

Best regards,
Community Support Team_ Binbin Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

[Anonymous]

This is what you are looking for:
https://community.powerbi.com/t5/Desktop/How-to-sort-month-in-order/m-p/42222

[Anonymous]

Hi Haseeb

Please can you share the screen shots. I could not find the modelling ribbon.

Thanks

Mahad