Get slicer value in M query as a comma separated string

Question

I have a slicer, and I want to get the multiple values selected in the slicer in the M query, to call an API with a filter as per the selected values.For testing purposes, I'm using sample data to load the slicer and using a measure to append the selected values into a string as below:I want to get the selected values in my M query, from where I'm calling the API.&nbsp;&nbsp;let
// Define the base URL of the API
baseURL = "https://api.example.com/data",

// Define the OData filter
odataFilter = "?$filter=Name in ('John','Sam')",

// Construct the full URL with the OData filter
fullURL = baseURL &amp; odataFilter,

// Call the API
apiResponse = Web.Contents(fullURL),

// Convert the response to JSON
jsonResponse = Json.Document(apiResponse),

// Convert the JSON response to a table (if applicable)
// Replace "Record.FieldValues" with the appropriate function to extract data from your JSON response
dataTable = Table.FromRecords({Record.FieldValues(jsonResponse)})
in
dataTable&nbsp;&nbsp;

amitchandak · Accepted Answer

dixanthomass , I doubt you can get the selected value in M, unless we use the dynamic M parameter 
&nbsp;
https://blog.crossjoin.co.uk/2020/10/25/why-im-excited-about-dynamic-m-parameters-in-power-bi/

Forum Discussion

Related content

Separate hierarchcal slicers

How to convert Table/list into comma separated string

Thousand-Separator-and-Decimal-Separator

Architecture decision : Separate workspaces

Slicer Filtering with URL query string parameter