Return Top N 3 rows for a Table Visualization

[Xavier11]

Hi,

I have a table visualization which is coming from a table 'xx'. The last column is a count of 'Tickets' from the table 'xx' where 'Count(District)' is applied. Table 'xx' contains 'organization', 'name', and 'tickets' as well as other fields. There is a running number for the tickets, example INC1, INC2). The below pictorial illustration show the count of the ticket against the user of the organziation.

Had noticed that there is no 'Top N' filter for the 'Count of Tickets' in the power BI Filters. Please help to advice the methods to only return top 3 result. Tried a few options but it doesnt seems to work. Kindly appreciate the steps for this beginner user. Thank you in advance.

organization	Name	Count of Tickets
A	Jeremy	100
BB	Sharon	99
C	Tiwtty	70
DD	Elon	50
ZZ	Jennifer	25

[Xavier11]

Here is my view

[PabloDeheza]

Hi there!

To apply the Top N filter you should do it on Name for example and based on Count of Tickets value. So you are basically saying, "return the top 3 names by Count of Tickets"

It should look something like this:

Let me know if that helps!

[Xavier11]

From my view, there is no Top N

[PabloDeheza · Accepted solution]

The Top N works based on another column, so you should filter for example Name, based on Count. There you are filtering staight Count. Apply the filter to either Organization or Name and it should work.

[Xavier11]

Thank you! It works. I see, Top N only be applicable for 1 field