Retrieve data on table click

Sounds like you're connecting to a datasource and using it in direct query mode, and not import.  If that's true, then you want to either pull down the data and then use filters to restrict the content (statically in the query, or dynamically with slicers etc)....or you want to restrict the data downloaded in the first place.

I don't know of a way to pass a dynamic parameter to a query that would restrict the amount of data retrieved, after it's already loaded...meaning in direct query you pull the data and then the visuals operate on it.  You can certainly setup a query that restricts the amount of data by passing in a parameter value to restrict, but that's a static method.

You could achieve this by passing in an order as a query and build multiple queries with different order #, and then make those all available...that might get tedious depending on the number of them to build.

otherwise, I'd pull the data down and then operate with slicers.  1000s of records isn't big, IMHO, I'm working with data sets much bigger than that, and pull the data down to work on.