Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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!
Solved! Go to Solution.
Hi,
Please set the data type as whole number for sort column
Thanks
Hari
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
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.
Hi,
No other steps required. Check one more time from report view whether sort by column is correctly mapped to the column.
Thanks
Hari
@Hariharan_R : I have recreated but it is still the same, it is sorted in ascending order instead of descending.
Hi,
Please set the data type as whole number for sort column
Thanks
Hari