Forum Discussion

alfiethedog's avatar
alfiethedog
Frequent Visitor
8 years ago

Sorting Columns through Multiple Conditions

Hi Everyone,

 

I am trying to sort my columns in a specific order.  Is there a way to sort columns with MULTIPLE conditions.  As if "this column" = "text" AND "another column" = "text" then = column 1.  Etc.  I am trying to sort approx 20 columns though multiple conditions.

 

Thanks!

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable

    Hi alfiethedog,

     

    Current power bi only support single column sort, maybe you can enter to query editor and add a custom column with above condition to mark index, then use this column as sorting column.

     

    Regards,

    Xiaoxin Sheng