change sales rep by using parameter.

[Anonymous]

Is it possible to create a column where the person in charge of the sales is varied by a parameter?

I have the following list of sales representatives.

The change of the person in charge is done on a monthly basis. This is done irregularly.

So I was wondering if it is possible to select the monthly contact person by parameters.

I would like to set the selected person (Parameter) to be the person in charge for all months of the year.

Parameter

April：Rep1
May：Rep1
June：Rep1
July：Rep1
August：Rep2
September：Rep2
October：Rep2
November：Rep2
December：Rep2
January：Rep2
February：Rep3
March：Rep3

Please advise if you have any other ideas on how to deal with this kind of thing.

Thanks in advance,

[Anonymous]

@amitchandak 

Thank you for your help😊

[amitchandak · Accepted solution]

@Anonymous , Slicer can not change column value, They only change measure. You can have a table like that(table 2)  which you can join with your table based on the month