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.

[v-priyankata]

Hi @SaikumarV 

I hope the information shared was helpful to you. If your question has been answered, kindly mark the most relevant reply as the Accepted Solution. This small action can make a big difference for others who are looking for the same solution.

[v-priyankata]

Hi @SaikumarV 

I wanted to check if you had the opportunity to review the information provided. if issue got resolved please accept it as a solution, Please feel free to contact us if you have any further questions.

[v-priyankata · Accepted solution]

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.