Forum Discussion

Snagalapur's avatar
Snagalapur
Icon for Helper IV rankHelper IV
1 year ago
Solved

Top 10 records (absolute value) in bargraph.

Hi All,

 

Please suggest how to have top 10 records (absolute value) in bargraph.

Thank you.

 

  • Anonymous's avatar
    Anonymous
    1 year ago

    Thanks for ryan_mayu's concern about this issue.

     

    Hi, Snagalapur 

    I am glad to help you.

     

    You can use Top N function in visual filter directly like ryan_mayu.

     

    Or you can create two Measure:

    AbsoluteValueMeasure = ABS(SUM('Table'[Revenue]))

     

    Rank = RANKX(ALL('Table'), [AbsoluteValueMeasure], , DESC, Dense)


    Then drag Rank to Filter Pane for filtering:

     

     

    I hope my suggestions give you good ideas, if you have any more questions, please clarify in a follow-up reply.
    Best Regards,
    Fen Ling,
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

3 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable

    Thanks for ryan_mayu's concern about this issue.

     

    Hi, Snagalapur 

    I am glad to help you.

     

    You can use Top N function in visual filter directly like ryan_mayu.

     

    Or you can create two Measure:

    AbsoluteValueMeasure = ABS(SUM('Table'[Revenue]))

     

    Rank = RANKX(ALL('Table'), [AbsoluteValueMeasure], , DESC, Dense)


    Then drag Rank to Filter Pane for filtering:

     

     

    I hope my suggestions give you good ideas, if you have any more questions, please clarify in a follow-up reply.
    Best Regards,
    Fen Ling,
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

    • Snagalapur's avatar
      Snagalapur
      Icon for Helper IV rankHelper IV

       

       

      could you please suggest why rank doesnt show top 10 instead i get top 9.

       

  • you can try to use the Top N function in visual filter