Forum Discussion
Negative % sorting issue in Matrix visual
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
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 CBelow DAX will solve
% Rev = VAR A = DIVIDE([Amount],CALCULATE([TR],ALL('Consol Category Sort'[Consol Category],'Consol Category Sort'[Order])),0)Return A
4 Replies
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 CThanks for the support. Yes it's in Numeric only. I cracked the solution.
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
Below DAX will solve
% Rev = VAR A = DIVIDE([Amount],CALCULATE([TR],ALL('Consol Category Sort'[Consol Category],'Consol Category Sort'[Order])),0)Return A