Top 10 records (absolute value) in bargraph.

[Snagalapur]

Hi All,

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

Thank you.

[Anonymous · Accepted solution]

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]

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

[ryan_mayu]

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