Forum Discussion

jessimica1018's avatar
jessimica1018
Helper II
2 years ago
Solved

Connecting multiple parameters

Hey!! 

 

I don't know if this is possible or if I am going about it the wrong way but I have 3 parameters; division, department, & supervisor. I have all three of the parameters driving slicers and the department one also is driving the columns in two charts. I want the end user to choose like "Account Manager" and the AM supervisor, AM Department and Account Manager fields to all be choosen on all three with one button. 

 

I have tried the following but it cause multiple chooses for the same thing (I.e. 3 Accout Manager boxes, I just want one):

Parameter 3 = {
("Account Manager", NAMEOF('Submission Max 1'[Account Manager]), 0,"Account Manager"),
("Client Manager", NAMEOF('Submission Max 1'[Client Manager]), 1,"Client Manager"),
("Recruiter", NAMEOF('Submission Max 1'[Recruiter]), 2,"Recruiter"),
("Account Manager", NAMEOF('Submission Max 1'[AM Department]), 3,"Account Manager"),
("Client Manager", NAMEOF('Submission Max 1'[CM Division]), 4,"Client Manager"),
("Recruiter", NAMEOF('Submission Max 1'[Rec Department]), 5,"Recruiter"),

("Account Manager", NAMEOF('Submission Max 1'[AM Supervisor]), 3,"Account Manager"),
("Client Manager", NAMEOF('Submission Max 1'[CM Supervisor]), 4,"Client Manager"),
("Recruiter", NAMEOF('Submission Max 1'[Rec Supervisor]), 5,"Recruiter")

}

 

All other ways I've tried just throws errors. So it there a way to do this or am I going about it all wrong?
Any help would be much appriciated!
Thank you!! 

  • amitchandak  We ended up finding a work around that does exactly what I needed. Basically created a reference table and connected it to the parameters! 


    Thanks

     

2 Replies

    • jessimica1018's avatar
      jessimica1018
      Helper II

      amitchandak  We ended up finding a work around that does exactly what I needed. Basically created a reference table and connected it to the parameters! 


      Thanks