Field parameters

[SaikumarV]

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.

[v-priyankata]

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.

[SaikumarV]

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

[v-priyankata]

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.