Dashboard widget grouping

I have a large smartsheet with product codes as primary key and associated info with each code. Since you cannot show data wider than the width of the dashboard, I have to create multiple reports to show data for one code. Firstly, is there a way to link the reports so they show different info for the same code and second, is there a way to make a search function on the dashboard so the user can select whatever code they are interested in?