Order Month Column in Pivot Table

[milomilo2020]

Hi, I have this pivot table:

I want to order the months in a descendent way: Mar 21, Feb 21, Ene 21 in this example.

The Month Column is sorted by this one:

Which is numerical and is sorted Descendent, but it is not woking in the pivot table.

Any ideas? Thanks

[Thejeswar]

Hi @milomilo2020 ,

Sorting in the Data View does not guarantee you that your data in visuals will be sorted accordingly.

You can sort the data separately in the visuals. Using the ... in the visual header.

If that does not work due to some reason, if you already have a column that you can use to sort this column, you can use the Sort by columns options that let's you get the desired result

There is also a third option of creating a Custom Sort to get this work if the above two does not work

Regards,

[milomilo2020]

Hi, thanks but this is not working for the column in a pivot table. The column is sorted by a numeric column created to be like: 202201, 202202, 202203 . I put the sort of that one in Descendent. But the pivot still order it chronologicaly

[V-lianl-msft]

Hi @milomilo2020 ,

You cannot sort by column in the matrix.

You can try custom sorting the column field.

Based on the sample you provided, you have created a sort column for the month and year. You only need to use the rankx function to arrange this column in reverse order.

Desc = RANKX(Sheet2,Sheet2[MY_Sort],,DESC,Dense)

Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.