How to make the end user to enter any User ID in organization and filter the results accordingly

[NandhaKumarPBI]

 Hi All,

I am new to Power BI, I have created a stored procedure with two parameters (UserId, UserName). I created parameters inside power bi using manage parameter and linked in to the query. But, how do i make that to apprear in the dashboard so that all users will have the leverage to enter any username and see the details accordingly.

Can you kindly help me as how to make it appear in the dashboard and once the user enters the value in the search box that should fetch to the parameter.

[Jimmy801 · Accepted solution]

Hello @NandhaKumarPBI 

create a table with all users (or whatever you want to filter the report with), show it in the visuals, and ue SELECTEDVALUE to extract the selection of the user. Integrate this function into your measures.

Here an example

SumWithFilter = CALCULATE(SUM('Table'[Country]),filter('Table','Table'[Country]=SELECTEDVALUE('Filter'[Country])))

If this post helps or solves your problem, please mark it as solution (to help other users find useful content and to acknowledge the work of users that helped you)
Kudoes are nice too

Have fun

Jimmy