How to Use Filter chart Based on the dropdown Values

Hi Everyone,

I have a requirement in which I ahve data like this 

Now i want to sort data Based on Approved state , Sports Category 
Mainly Approved State and then want to show the data on line or bar chart

so Basically requirement is in the drop down all the approved state will be there and when I select one of the approved state the data will populate in the Bar/ Line chart

so how can I implement this pls share your solution 

Thanks
Lav