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

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
Anonymous
Not applicable

Top N and Others for Fields Parameter

There's a few different ways of displaying Top N values and then grouping the other values into an "Others" category. However, I am unsure how to do this using field parameters. I have multiple fields in my field parameter (Ex. value stream, cost category, cluster id, etc.) that I'd like to display in this format. When a field is chosen, I'd like to display the Top 10 values and then group the rest into an "Others" category. Is this possible?

1 REPLY 1
amitchandak
Super User
Super User

@Anonymous , I have not experimented with TOPN +other, Only switched TOPN with field parameter , refer if that can help

Switch TOPN with Field Parameters: https://amitchandak.medium.com/switch-topn-with-field-parameters-299a0ae3725f

 

My topN approach required a new table, which might create too many tables

Power BI- Power BI- TOPN with Others- https://youtu.be/I_TY4hVlzAE

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.