Elected members have been told they have two weeks to come up with someone to lead them or things could get much worse.