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

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

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
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

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

April Fabric Community Update

Fabric Community Update - April 2024

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