Forum Discussion
Return Top N 3 rows for a Table Visualization
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 |
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.
5 Replies
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!
From my view, there is no Top N
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.
Here is my view
