I have created the following report in Power BI
The above report shows manufacturing performance for one particular customer. Each customer has different models.
On a particular year, we may not have supplied any particular model. When I select year on the slicer the model slicer should update automatically for the sppllicable models.
Waiting for your response.