Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.