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.
- Snagalapur1 year ago
Helper IV
could you please suggest why rank doesnt show top 10 instead i get top 9.