Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

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

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

dataflow
  • Anonymous's avatar
    Anonymous
    6 years ago

    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

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    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