Sorting by Criteria and multiple Columns in Visual Table in Power BI

[Anonymous]

I have three columns in table visual in Power BI

Showing ID and the number of bookings related to them

Here is the visual shown in Excel which I have exported from Power BI 

Work Order Bookings and Created is from the same table but No of Bookings is a Dax calulation (Using Ranx)

Is it possible to sort out the table visual in power Bi is this format?

I want the rank in order of DESC and them to link to the date of creation and then linked to specific ID like this

so Ordered by Create Date by Id.

Thanks for the responses

[Anonymous · Accepted solution]

HI @Anonymous,

You can setting multiple column sort orders in query editor, then add a index column for current sorting order.
After these steps, please use the new index column as sorting ordering field to keep that current sort order.

Regards,

Xiaoxin Sheng