Trying to understand top10 to show in visual

[guyatisk]

I dont know why I cannot get this working, but I have the following data with Charge and ChargeCount.  I want to only show the Top 10.  I have tried Rankx, Topn, etc, but there is something that is not clicking.  Would it be a measure that I use and what would that formula look like?  

This is just the first 37 rows of a dataset that is hundreds of records long.  I appreciate the help

Charge	Count of Charge
DROVE WHILE LICENSE SUSPENDED/REVOKED/DENIED	90
SPEEDING 1-10 MPH OVER LIMIT	80
PARK/CITY OF KAL-EXPIRED METER	38
DOMESTIC VIOLENCE	37
ASSAULT OR ASSAULT AND BATTERY	30
EXPIRED OR NO PLATE ON VEHICLE	30
CONT SUBS-POSSESSION OF METHAMPHETAMINE	26
INSURANCE-NO PROOF OF INSURANCE	25
LICENSE-DROVE WHILE UNLICENSED	24
POLICE OFFICER-ASSAULTING RESISTING OBSTRUCTING ATTEMPTED	22
TRESPASS	21
FAIL TO YIELD	18
HOUSING CODE VIOLATION 1ST OFFENSE	16
RETAIL FRAUD	14
SPEEDING ON LIMITED ACCESS HWY 1-10 MPH OVER LIMIT	14
ASSAULT WITH DANGEROUS WEAPON (FELONIOUS ASSAULT)	13
DISOBEY TRAFFIC SIGNAL	13
FAIL TO STOP OR IDENTIFY AFTER PROPERTY DAMAGE ACCIDENT	13
PARK/CITY OF KAL-OVERTIME	13
RETAIL FRAUD - THIRD DEGREE	13
DOG-FAIL TO BUY DOG LICENSE-LOCAL ORDINANCE	12
BAC.17-OPERATING WITH BLOOD ALC CONTENT OF .17 OR MORE	10
FAIL TO STOP WITHIN ASSURED CLEAR DISTANCE	9
OPERATING WHILE INTOXICATED 1ST OFFENSE	9
POLICE OFFICER-ASSAULTING RESISTING OBSTRUCTING	9
RETAIL FRAUD - SECOND DEGREE	9
CONT SUBS-POSSESSION (NARCOTIC OR COCAINE) LESS THAN 25 GRAMS	8
DISTURBING THE PEACE	8
DOMESTIC VIOLENCE - SECOND OFFENSE NOTICE	8
LICENSE-DROVE WHILE LICENSE EXPIRED-LOCAL ORDINANCE	8
CMV-DROVE CMV WITHOUT GROUP A DESIGNATOR	7
DROVE WITHOUT DUE CARE & CAUTION	7
IMPAIRED-OPERATING WHILE IMPAIRED BY LIQUOR	7
LICENSE-DROVE WHILE LICENSE NOT VALID OR IMPROPER	7
LICENSE-NO LICENSE-NEVER APPLIED	7
MALICIOUS DESTRUCTION OF PERSONAL PROP $200 OR MORE < $1 000	7
STALKING	7

[AliNoorani · Accepted solution]

Hi, have you tried using visual level filter. 

Here's a guide: https://powerbidocs.com/2020/01/21/power-bi-top-n-filters/

[guyatisk]

As you responded, I found what I was doing.  For the count column I was trying to change the filter type, but it was only allowing me to filter by a number.  Then I switch it to filter by the TEXT column, Charge, and I found the TopN filter.  Thanks for the response though

[AliNoorani]

I am glad the problem is solved 🙂