Forum Discussion

dineshkumar_vrv's avatar
dineshkumar_vrv
Helper I
8 years ago
Solved

sorting issue

  I have tried converting the data type of payments and quantile to fixed decimal , whole number but quantile column is still not in proper order as I displayed in the second figure. Pleas...
Need Help
  • v-ljerr-msft's avatar
    v-ljerr-msft
    8 years ago

    Hi dineshkumar_vrv,

     

    Currently, only one column can be sorted with the sort option in Power BI. Here is an idea about adding a multiple columns sort feature. You can vote it up and add your comments there to improve Power BI on this feature.

     

    In addition, an alternative way to sort both payment column and Quantile column is using the formula(DAX) below to add a new calculate column in your table, then sort by the new created column. :smileyhappy:

    Column4 = Table2[payment]+Table2[Quantile]

    Regards

dineshkumar_vrv's avatar
dineshkumar_vrv
Helper I
8 years ago

Formula have syntax error please look into the image Kindly suggest to resolve the error

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Post your code please, maybe the delimitters are different on your client? , instead of ; ?

  • dineshkumar_vrv's avatar
    dineshkumar_vrv
    Helper I
    8 years ago

     

    Error Message : The syntax for ';' is incorrect. (DAX(RANKX( ALLSELECTED(Hospital_Gen_Res_QR[Payments]); Hospital_Gen_Res_QR[Payments]; ;ASC))).

     

     

    Rank =
    RANKX(
     ALLSELECTED(Hospital_Gen_Res_QR[Payments]);
     Hospital_Gen_Res_QR[Payments];
     ;ASC
    )

    • Anonymous's avatar
      Anonymous
      Not applicable
      8 years ago

      Syntax is correct, try to change ; with , ? 

       

      Rank2 =
      RANKX(
      ALLSELECTED(Table1[Payment]),
      Table1[Payment],
      ,ASC
      )

      • dineshkumar_vrv's avatar
        dineshkumar_vrv
        Helper I
        8 years ago

        Thank you formula worked but sorting issue still prevails , it sorts only the payment column in ascending and Quantile column is not sorted in ascending.

         

        My requirement is to sort payment and quantile in ascending order