Forum Discussion
Solved
Multi-tiered Custom Sort as in Excel
Re-posting since the original request was marked complete even though it wasn't. I use Power BI to create invoices for our clients. I need the ability to sort my entire table at 3 different level...
Hi there.
I myself have not familiarized myself with multi-level sorting in Power BI, but I believe you can do it.
In the Power Query editor, click the drop down next to the first column you want to sort. You can then repeat this for the second and third level columns.
Your applied step will look something like this:
= Table.Sort(#"Multi-level Sort",{{"Customer ID", Order.Ascending}, {"Products by Supplier", Order.Ascending}, {"Prices", Order.Ascending}})Hope this helps!
Hi there.
I myself have not familiarized myself with multi-level sorting in Power BI, but I believe you can do it.
In the Power Query editor, click the drop down next to the first column you want to sort. You can then repeat this for the second and third level columns.
Your applied step will look something like this:
= Table.Sort(#"Multi-level Sort",{{"Customer ID", Order.Ascending}, {"Products by Supplier", Order.Ascending}, {"Prices", Order.Ascending}})Hope this helps!