Pivot /Matrix table sorting

[analysiswithtec]

Hi community,

I have a pivot/matrix table that gives me the following table:

Debtors	100
Prepayments	80
Creditors	-20
Accruals	-60

I want to sort it by absolute size but first by positives then by negatives, to give the following:

Debtors	100
Prepayments	80
Accruals	-60
Creditors	-20

Is there any way to achieve this?

Thanks

[V-lianl-msft · Accepted solution]

Hi @analysiswithtec ,

You may add calculated columns and then sort by the calculated columns.

Column = IF('Table'[Column2]>0,1,0)

Column_test = IF('Table'[Column]=0,'Table'[Column2]*-1,'Table'[Column2])

Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[parry2k]

@analysiswithtec I guess these values are measures? 

[analysiswithtec]

Yes I have used a simple measure such as sum()