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 largest?  Thanks in advance for your help!   

 

 

  • 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

4 Replies

  • v-yulgu-msft's avatar
    v-yulgu-msft
    Microsoft Employee

    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

    • SRIKER's avatar
      SRIKER
      Regular Visitor

      Thank you v-yulgu-msft.  This is exactly what need!  Unfortunately my Premium version does not seem to have the Add Column tab no the Conditional Column button.  Double checked my version and I'm up to date.  Bummer!

      • SRIKER's avatar
        SRIKER
        Regular Visitor

        Sorry! I'm a rookie over here.  Found it!.  Thanks again for your help!