Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
Hi there,
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. country, incoterms, material, plants etc.) that I'd like to display in this format. When a field is chosen, I'd like to display the Top 3 (better to be dynamic, however) values and then group the rest into an "Others" category.
I tried using multiple tables for each field parameter, and a lot of variables, but it's loading really really slow, and in PBI Service it's not even showing (the error I get is : visual has exceeded the available resources).
The tutorial I followed is this one: https://www.youtube.com/watch?v=nVvlEHKr_0o
Below you can see my formula which works, but I need something simpler to load easier and be visible in PBI Service as well:
You would need to create the "Other" row for all parameter fields, and then you would also need to prevent users from selecting more or less than one field parameter (which kinda defeats the purpose of field parameters).
Filtering the top products alongside the other products in Power BI - SQLBI
May not be worth the effort?
User | Count |
---|---|
45 | |
26 | |
21 | |
18 | |
18 |
User | Count |
---|---|
51 | |
45 | |
24 | |
24 | |
21 |