Forum Discussion
Sort by is not working
I have a matrix and I want the Row item (called Product) to be sorted in a specific order so I created a column in Query Editor called 'Order' and i've used an IF statement to define the order as 01,...
Anonymous
Can you share the workbook with us so as to have a look at it?
I've attached some screenshots of the relevant areas, I can't attach the worksheet due to the data it contains.
In Query Editor, the Order column is 'whole number'The M Query formula used to create the 'Order' columnThe Row item is sorted by 'Order'In the table, the Order column still shows as Whole Number and contains values 1 to 26
Hi Anonymous,
Based on my research, you could refer to below link to custom sort your column:
https://community.powerbi.com/t5/Desktop/Custom-Sorting-in-PowerBI/td-p/126534
Regards,
Daniel He
