Forum Discussion
Solved
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 ab...
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
Thanks 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