Forum Discussion
Urgent help needed on Sorting columns
Hi All, Please help to solve below sorting columns. I am uable to get it exact sorting based on my requirement. The default sorting in Power BI is only one column is giving sort. But as per t...
Anonymous
pls see if this is what you want
Data types are correct for these 3 columns, but still the same issue as excepted sorting is not coming as per the requirement.
Sort Order like:
P Name should be Alphabetical Order (ASC)
Date & Time (ASC)
P Number (ASC)
Hi Anonymous - can you try below approach by creating new column sortkey as power bi sometimes ignores multiple sort orders in visuals. To force it:
SortKey = P_Name & FORMAT([Date & Time], "YYYYMMDDHHMMSS") & FORMAT([P Number], "0000000")
Go to Model View → Select the Table.Click "Sort by Column" → Choose "SortKey".Use this new column for sorting in your table visual.
Please check and confirm.
