TOPN filter output not ideal

[Anonymous]

I'm using a TOPN filter on a visual, and it is showing more than the number prescribed.  This is because they all have an identical value.  This visual is meant to be a snapshot of the current state of this part of the business, so the extra lines are not required.  Is there a way to "hard limit" it to TOPN, just choosing the necessary number for the visual?

Thanks

[v-xulin-mstf]

Hi @Anonymous,

Maybe it is not supported to sort duplicate values using TOP N, you can add index column to get your expected output.

Best Regards,

Link

[Anonymous]

I like your solution, except I'm working with measures.  Your solution definitely has a place with other applications and I will try to remember it.  Thanks for your reply!

[lbendlin · Accepted solution]

add a very small random number to your values.