sorting issue

[dineshkumar_vrv]

I have sorted by Payment but still my Quantile column is not sorted accordingly to the sorted payment by ascending order why ? please suggestSame data but different tool has sorted correctly , I want to achieve this order in power bi

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. Please suggest

[Anonymous]

Hi @dineshkumar_vrv,

As I can spot in your first image, it looks like the table is sorted on the payment column instead in the Quantile column.

Can you click on the Quantile column to see if sorting works? 

[dineshkumar_vrv]

I have tried sorting with quantile column before but the payment column's(52.74) is in the second place where as 52.74 should be in the first place rite ? I want both the columns to be sorted in ascending order

[v-ljerr-msft · Accepted solution]

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. 

Column4 = Table2[payment]+Table2[Quantile]

Regards

[Anonymous]

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
)

[dineshkumar_vrv]

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

[Anonymous]

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

[dineshkumar_vrv]

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]

Syntax is correct, try to change ; with , ? 

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

[Anonymous]

Use the approach @v-ljerr-msft mentioned or if you don't want to store the concatenated column use

Rank2 = 
RANKX(
 ALLSELECTED(Table1[Payment]);
 Table1[Payment]&"-"&Table1[Quantile];
 ;ASC
)

[dineshkumar_vrv]

Ok Thank you ,v-ljerr-msft suggestion work well but with extra column.

[dineshkumar_vrv]

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