Forum Discussion
sorting issue
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
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
Hi dineshkumar_vrv,
The option v-ljerr-msft is possible and as long as multi-sort columns is not supported a solution that would work. Only thing that I doubt is the possibility of false positions because of the addition of the quantile to the value. You can also use ranking to sort in a calculated column.
Rank = RANKX( allselected(Table1[Payment]); Table1[Payment]; ;ASC )
Formula have syntax error please look into the image Kindly suggest to resolve the error
Post your code please, maybe the delimitters are different on your client? , instead of ; ?
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
)
