Forum Discussion
How To Sort Columns based on other columns with duplicate values
I have 3 columns:
- destination town
- destination branch
- destination town index
The index columns are whole numbers that represent the actual geographical location of each town. I have pivot table matrix with origin town and destination town, and by default, the pivot sorts the towns by alphabetical order.
I would like to sort the towns by index but can't figure out how to as there are duplicates in town & index columns as per screenshot below.
How do I overcome this?
3 Replies
Hi. If you want to order a column by other value you can do it. Go to Data View and select a column, then under modeling tab you will find a "Sort Column by" or something like that. Check the picture out:
sort col by
For more info: https://docs.microsoft.com/en-us/power-bi/desktop-sort-by-column#sort-using-the-sort-by-column-button
Regards,
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
