Forum Discussion

SRIKER's avatar
SRIKER
Regular Visitor
8 years ago
Solved

SORT Order

Self teaching Power BI and can't quite seem to get the correct DAX to sort diameter sizing depicted as the column headers here.  How can I get the matrix to sort the diameters from smallest to larges...
  • v-yulgu-msft's avatar
    8 years ago

    Hi SRIKER,

     

    Add a conditional column in Query Editor mode.

     

    In data view mode, change the default sort by column to [Sort Order].

     

    Result.

     

    Best regards,

    Yuliana Gu