Do the suggestions from engineers make sense? If so, kindly mark the proper reply as a solution to help others having the similar issue and close the case. If not, let me know and I'll try to help you further.
The dynamic URL filter have the structure : URL?filter=Table/Field eq 'value' . So you may change your link like below, assuming the "Table" in URL below is referred to your fact data table, and the 'PROD 2020' is in field [ProdYear].