Sort columns in a matrix by month - year

[pgarcia]

Hi all!

I would like to compare the values of a month between different years in a matrix visual, so I want to sort the columns of the matrix by the month - year hierarchy

In this case I want December to appear before January because in December I am comparing with year 2015.

How could sort by month-year??

Thanks so much.

Best regards

[v-yuezhe-msft · Accepted solution]

@pgarcia,

What does your original table look like? If you have sample data as follows, when you create the Matrix, December should appear before January by default.



If you encounter issues by sorting, consider to add a conditional column as shown in  the following screenshot. Then sort the Month column by the new column.


Regards,
Lydia