Forum Discussion

M_Kishore's avatar
M_Kishore
New Member
3 years ago
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...
Need Help
  • pratyashasamal's avatar
    pratyashasamal
    3 years ago

    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's avatar
    M_Kishore
    3 years ago

    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's avatar
pratyashasamal
Memorable Member
3 years ago

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's avatar
M_Kishore
New Member
3 years ago

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

  • pratyashasamal's avatar
    pratyashasamal
    Memorable Member
    3 years ago

    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