Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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?
@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