Forum Discussion
Field parameters
How to filter top 1000 rows of data in field parameter. when I have huge of amount of data, I want to see only top 1000 or 2000 rows of data from field parameter in power bi.
Hi SaikumarV
Hope everything’s going smoothly on your end. We haven’t heard back from you, so I wanted to check if the issue got sorted. If yes, marking the solution would be awesome for others who might run into the same thing.
6 Replies
Hello SaikumarV
Thank you for reaching out to the Microsoft Fabric Forum Community.I have successfully reproduced your scenario in Power BI, please have a look.
For your reference, I’m attaching the .pbix file so you can explore the solution in detail.
1. Create a Field Parameter - Modeling > New Parameter > Fields - Add the fields you want & name the parameter.
2. Create a Numeric Parameter for Top-N - Modeling > Numeric Range Parameter - Set the minimum to 1, maximum to 2000, and increment as needed (e.g., 100).
3. Create the Rank & Filter measure and apply the filter to visuals.Also, I have one thread related to the same issue; please have a look at this too Solved: How to Filter Top N with Field Parameters? - Microsoft Fabric Community
If this information is helpful, please “Accept as solution” and give a "kudos" to assist other community members in resolving similar issues more efficiently.
Thank you.If we are using same table columns in field parameter is fine, However If I am using different columns from multiple tables, how to achieve the topN 1000 rows of data
Hello @SaikumarV
Thank you for reaching out to the Microsoft Fabric Forum Community.If you want to use different columns from multiple tables, follow the same process with little changes like below.
FYI - Ensure that relationships between your tables are properly defined in the data model.
1. Create a Field Parameter - Modeling > New Parameter > Fields - Add the fields from different tables & name the parameter.
2. Create a Numeric Parameter for Top-N - Modeling > Numeric Range Parameter - Set the minimum to 1, maximum to 2000, and increment as needed (e.g., 100).
3. Create the Rank & Filter measure and apply the filter to visuals.If this information is helpful, please “Accept as solution” and give a "kudos" to assist other community members in resolving similar issues more efficiently.
Thank you.
