How to filter a table on value selection

Hi Sophie_ ,

Do you mean that you want to filter your underlying table by parameter slicer?

As far as I know, dynamic M query parameters only support Direct Query connection mode.

For reference:

Dynamic M query parameters in Power BI Desktop - Power BI | Microsoft Learn

If you want to filter the visual, you can create a relationship between the parameter table and data table, then create the vsiual. 

If you don't want to create a relationship between them, I suggest you to create a measure to filter your visual in visual level filter. Here is a solved post with similar issue like yours, I hope it could help you.

For reference:Solved: Parameters and slicers - Microsoft Fabric Community

Best Regards,
Rico Zhou

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.