How to create a parameter query that takes multiple values?
I have 2 query tabs(PQ) initially eventually it will be 3 tabs(different views- detailed and specific) that are embedded with SQL code. In the parameter tab, I have the parameter query table that only takes one value for now. When the value is entered under the Value field and refreshed it should fetch one or more ID details in the query tabs.
Adding a slicer would not be much of help here as a slicer is applied per table/pivot. Correct me if I'm wrong.
Is there a workaround?