Forum Discussion
Field parameters
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.
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.
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.
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.
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.