• You can just add a filter on the Category in the chart.

    I'd suggest you look up "data regions" in SSRS to help you understand the scope of filters and what will be affected. E.g. filtering the dataset would affect both the chart and the table, filtering the chart (which is a data region) will not affect the table, and visa versa.