Forum Discussion
Top 10 records (absolute value) in bargraph.
- 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.
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.
could you please suggest why rank doesnt show top 10 instead i get top 9.