Sorting Columns through Multiple Conditions

[alfiethedog]

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!

[Anonymous]

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