Custom Sort as in Excel

[SDigital007]

Hi,

I use Power BI to create invoices for our clients. I need the ability to sort my entire table using 3 columns as in Excel: Column 1: Customer Id from A to Z, Column 2: Products by Supplier A-Z, Column 6: Prices from high to low. 

I cannot find the equivalent to this Excel function in Power BI. Any ideas?

[Anonymous]

If you perform the sortation at the power query level, one at a time, in the order listed below, you should end up with the correct result.

[SDigital007]

Thank you for the suggestion but it doesn't work. Sorting at the second level scrambles the 1st, undoing the order of customer IDs. What I am looking for is a way to sort by level: 1st customer ID, then for each customer ID, sort by product type, then for each product type, sort by price.

The end goal is to create line items for customer invoices.