Sorting Columns in Matrix Visual

[poojithas]

Hi All.

I am using a matrix visual with YYYYMM as Columns , cardtype as Rows and few measures as Values.

I am trying to sort YYYYMM in descending order but I do not find an option to do. Can someone please let me know how this can be achieved dynamically. Please note that the datatype of  YYYYMM is TEXT which is coming in directly from the database. We will not be able to bring the date field into the report.

Thanks!

[Hariharan_R]

Hi

Matrix visual doesn't has option to sort the column values so you need to sort it using "Sort By Column".

1. Creat one columns in Power Query Layer like below.

2. Use that new column to sort

Check the visual now,

Thanks

Hari

Did I answer your question? Then please mark my post as the solution.
If I helped you, click on the Thumbs Up to give Kudos.

My Blog :: YouTube Channel :: My Linkedin

[poojithas]

Hi @Hariharan_R , I have followed the same but by default it is sorted in Ascending order. Is there any additional steps to be done to sort in desc order.

[Hariharan_R]

Hi,

 No other steps required. Check one more time from report view whether sort by column is correctly mapped to the column.

Thanks

Hari

Did I answer your question? Then please mark my post as the solution.
If I helped you, click on the Thumbs Up to give Kudos.

My Blog :: YouTube Channel :: My Linkedin

[poojithas]

@Hariharan_R  : I have recreated but it is still the same, it is sorted in ascending order instead of descending.

[Hariharan_R · Accepted solution]

Hi,

Please set the data type as whole number for sort column

Thanks

Hari

Did I answer your question? Then please mark my post as the solution.
If I helped you, click on the Thumbs Up to give Kudos.

My Blog :: YouTube Channel :: My Linkedin

[poojithas]

@Hariharan_R  - This worked. thank you!