Please use the actions for this.
Please attach workbook.
Here I have attached one workbook. Please check this and let me know if you need more help on this.
I have not used relevant value option here. I have created two different chart and bring both chart in dashboard.
There are two filter. 1. Category 2. Subcategory
Once you filter in category then you'll be able to see only subcategory related to that particular category.
Please mark correct and Helpful if it works for you
Filter.twbx 1.1 MB