Forum Discussion
Top 10 records (absolute value) in bargraph.
Hi All,
Please suggest how to have top 10 records (absolute value) in bargraph.
Thank you.
- Anonymous1 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
- AnonymousNot 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
Helper IV
could you please suggest why rank doesnt show top 10 instead i get top 9.
- ryan_mayu
Super User
you can try to use the Top N function in visual filter