How do I solve pass parameters by users

[ali_a]

Hi there, 

I have been trying many of way to let users enter value in the parameter by using power bi server report for my organization. 

Please, I need to solve this problme by any way. An addition, it's only work by this way -> Home -> Edite Queries -> Edit parameters.

 select sum (db.fun_gt.g_m_c ( a.branchoff, 
                               a.cntno ,
                               db.fun_date (db.dte_pkg.g2h (TO_DATE ('31122018','ddmmyyyy')))))  as sum
  from db.Test a;

/*With parameter*/
 select sum (db.fun_gt.g_m_c ( a.branchoff, a.cntno , db.fun_date 
(db.dte_pkg.g2h (TO_DATE ('"&Pass_Date&"','ddmmyyyy'))))) as sum 
from db.Test a;

Thanks 🙂