Forum Discussion
poojithas
Helper III
Helper IIISorting Columns in Matrix Visual
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 someon...
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
Hariharan_R
Solution Sage
Solution SageHi
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
If I helped you, click on the Thumbs Up to give Kudos.
My Blog :: YouTube Channel :: My Linkedin
poojithasHi 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.