Share feedback directly with Fabric product managers, participate in targeted research studies and influence the Fabric roadmap.
Sign up nowGet Fabric certified for FREE! Don't miss your chance! Learn more
I have a matrix where I am displaying data on product reviews. The reviews are categorized by Theme. Every theme then has a number of description tags to categorize more specific themes. At the moment the matrix shows the quantity of reviews by theme. I can then expand each theme to break the quanity down by description tags. I want to break it down even further by breaking down the quanity of each description tag by product id. I am able to do this. However, I am wondering if there is a way that I can only display the top 5 or 10 most common products rather than having a long list of products.
@ErickR99 , you can use TOPN filter or TOPN measure
TOPN: https://youtu.be/QIVEFp-QiOk
example
Top 10 Customers =
CALCULATE( [Total Sales],
TOPN( 10, ALL(Customer_Lookup[customer names]), [Total Sales], DESC),
VALUES( Customer_Lookup[customer names] ))
Power BI- Power BI- TOPN with Others- https://youtu.be/I_TY4hVlzAE
Share feedback directly with Fabric product managers, participate in targeted research studies and influence the Fabric roadmap.
If you love stickers, then you will definitely want to check out our Community Sticker Challenge!
Check out the January 2026 Power BI update to learn about new features.
| User | Count |
|---|---|
| 63 | |
| 62 | |
| 42 | |
| 20 | |
| 18 |