right click on chart ->chart properties>filters>select correct expression which is related to year select operator != then value = blank or =0.. should work.. it worked for me