Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now

Reply
guyatisk
Helper I
Helper I

Trying to understand top10 to show in visual

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

 

ChargeCount of Charge
DROVE WHILE LICENSE SUSPENDED/REVOKED/DENIED90
SPEEDING 1-10 MPH OVER LIMIT80
PARK/CITY OF KAL-EXPIRED METER38
DOMESTIC VIOLENCE37
ASSAULT OR ASSAULT AND BATTERY30
EXPIRED OR NO PLATE ON VEHICLE30
CONT SUBS-POSSESSION OF METHAMPHETAMINE26
INSURANCE-NO PROOF OF INSURANCE25
LICENSE-DROVE WHILE UNLICENSED24
POLICE OFFICER-ASSAULTING RESISTING OBSTRUCTING ATTEMPTED22
TRESPASS21
FAIL TO YIELD18
HOUSING CODE VIOLATION 1ST OFFENSE16
RETAIL FRAUD14
SPEEDING ON LIMITED ACCESS HWY 1-10 MPH OVER LIMIT14
ASSAULT WITH DANGEROUS WEAPON (FELONIOUS ASSAULT)13
DISOBEY TRAFFIC SIGNAL13
FAIL TO STOP OR IDENTIFY AFTER PROPERTY DAMAGE ACCIDENT13
PARK/CITY OF KAL-OVERTIME13
RETAIL FRAUD - THIRD DEGREE13
DOG-FAIL TO BUY DOG LICENSE-LOCAL ORDINANCE12
BAC.17-OPERATING WITH BLOOD ALC CONTENT OF .17 OR MORE10
FAIL TO STOP WITHIN ASSURED CLEAR DISTANCE9
OPERATING WHILE INTOXICATED 1ST OFFENSE9
POLICE OFFICER-ASSAULTING RESISTING OBSTRUCTING9
RETAIL FRAUD - SECOND DEGREE9
CONT SUBS-POSSESSION (NARCOTIC OR COCAINE) LESS THAN 25 GRAMS8
DISTURBING THE PEACE8
DOMESTIC VIOLENCE - SECOND OFFENSE NOTICE8
LICENSE-DROVE WHILE LICENSE EXPIRED-LOCAL ORDINANCE8
CMV-DROVE CMV WITHOUT GROUP A DESIGNATOR7
DROVE WITHOUT DUE CARE & CAUTION7
IMPAIRED-OPERATING WHILE IMPAIRED BY LIQUOR7
LICENSE-DROVE WHILE LICENSE NOT VALID OR IMPROPER7
LICENSE-NO LICENSE-NEVER APPLIED7
MALICIOUS DESTRUCTION OF PERSONAL PROP $200 OR MORE < $1 0007
STALKING7
1 ACCEPTED SOLUTION
AliNoorani
New Member

Hi, have you tried using visual level filter. 

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

 

View solution in original post

3 REPLIES 3
AliNoorani
New Member

Hi, have you tried using visual level filter. 

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

 

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

I am glad the problem is solved 🙂

Helpful resources

Announcements
Fabric Community Conference

Microsoft Fabric Community Conference

Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.

February 2024 Update Carousel

Power BI Monthly Update - February 2024

Check out the February 2024 Power BI update to learn about new features.

Fabric Career Hub

Microsoft Fabric Career Hub

Explore career paths and learn resources in Fabric.

Fabric Partner Community

Microsoft Fabric Partner Community

Engage with the Fabric engineering team, hear of product updates, business opportunities, and resources in the Fabric Partner Community.