Show top X

[stribor45]

My column has ID of the order type and I am doing the count on it. I would like to show the top 5 but it is showing me options only as to greater or less than etc (see below).  I can get away for now just saying "show greater than 5000" but would prefer "top x" which I saw before but now I only see this option.

[v-binbinyu-msft · Accepted solution]

Hi @stribor45 ,

Table field has "Top N" filter type, measure does not has it type in visual filter pane.

Best regards,
Community Support Team_Binbin Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Ritaf1983 · Accepted solution]

Hi @stribor45 
TOP N is a different "type" of filter that you should select in the previous step:

Another way of working with top N is to modify it with Dax.

For more information please see linked tutorial:

https://www.youtube.com/watch?v=vpGAf6Nkt1Q&t=4s

If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly

[v-binbinyu-msft · Accepted solution]

Hi @stribor45 ,

Table field has "Top N" filter type, measure does not has it type in visual filter pane.

Best regards,
Community Support Team_Binbin Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.