Negative % sorting issue in Matrix visual

[M_Kishore]

Hi Power BI Community,

I'm trying to sort as per slno in matrix table, it is a simple divde measure. Kindly refer below snaps for refrence.

consol category is sorted as it own, in this we are able to see all -ve & +ve % of Revenue.

after sorting with consol category sort order all neagtive % are not apperaing 

for sorting purpose created required template, that is not help full.

simple measures like sum of totalsales / sum of revenue.

Kndily provide solution

Thanks in advance.

Regards,

M

[pratyashasamal · Accepted solution]

Hi @M_Kishore ,
Make sure If this is a column that you are using in Sort By column is numeric .
You can refer to this youtube video :-
https://www.youtube.com/watch?v=72qQrPw4RuE&t=304s
Thanks,
Pratyasha Samal
Has this post solved your problem? Please Accept as Solution so that others can find it quickly and to let the community know your problem has been solved.
If you found this post helpful, please give Kudos C

[M_Kishore · Accepted solution]

Below DAX will solve 

% Rev = VAR A =  DIVIDE([Amount],CALCULATE([TR],ALL('Consol Category Sort'[Consol Category],'Consol Category Sort'[Order])),0)

Return A

[pratyashasamal · Accepted solution]

Hi @M_Kishore ,
Make sure If this is a column that you are using in Sort By column is numeric .
You can refer to this youtube video :-
https://www.youtube.com/watch?v=72qQrPw4RuE&t=304s
Thanks,
Pratyasha Samal
Has this post solved your problem? Please Accept as Solution so that others can find it quickly and to let the community know your problem has been solved.
If you found this post helpful, please give Kudos C

[M_Kishore]

Thanks for the support. Yes it's in Numeric only. I cracked the solution.

[pratyashasamal]

Oh nice .
hope i could help you .
Has this post solved your problem? Please Accept as Solution so that others can find it quickly and to let the community know your problem has been solved.
If you found this post helpful, please give Kudos C