Forum Discussion
sort values in number column based on text column in Table View
It does make sense but not where you want to. I am not aware of a "Sort by and then by" function in PowerBI in Table view. I know it exists in other programs but not in PowerBI. However, if you create a Table visual then the sorting will be done automatically (You sort column 1 and then 2 will be sorted by itself).
hi, thanks for responding.
when i try to do a sort on column 1 in ascending order thats fine. the data is sorted in ascending order. however i need to do a second sort on the column 2 which holds the years value but when i try to do a sort on this column - although it sorts it (from 1994 - 2024) it messes up column 1 and the countries are not in ascending order.
how can i keep the sort in ascending on column1 and also sort on column 2 without it affected column 1? does that make more sense?
Solution SageIt does make sense but not where you want to. I am not aware of a "Sort by and then by" function in PowerBI in Table view. I know it exists in other programs but not in PowerBI. However, if you create a Table visual then the sorting will be done automatically (You sort column 1 and then 2 will be sorted by itself).