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

Power BI is turning 10! Let’s celebrate together with dataviz contests, interactive sessions, and giveaways. Register now.

Reply
POWER_PAT
New Member

Slicer based on count of text value in a column

I'm trying to create a "between" slicer the includes or excludes categories based on the number of times they appear in the data set. 

 

Want to filter out categories that only appear a few times to only focus on those that appear in high volume.

 

Thanks for any help!

 

 

1 ACCEPTED SOLUTION

I kept searching and found this that just worked - created new tablet with below. 

 

= GROUPBY(Table1,Table1[User ID],"Count of login",COUNTX(CURRENTGROUP(),Table1[Login time]))

View solution in original post

2 REPLIES 2
Anonymous
Not applicable

Create a calculated column that counts rows an use that as a filter. Something like
Cnt=countrows(filter(table;table[col]=earlier(table[col]))
But without other info is difficult to help you

I kept searching and found this that just worked - created new tablet with below. 

 

= GROUPBY(Table1,Table1[User ID],"Count of login",COUNTX(CURRENTGROUP(),Table1[Login time]))

Helpful resources

Announcements
June 2025 Power BI Update Carousel

Power BI Monthly Update - June 2025

Check out the June 2025 Power BI update to learn about new features.

June 2025 community update carousel

Fabric Community Update - June 2025

Find out what's new and trending in the Fabric community.