Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Set M Query parameter Select All slicer option to return list of selections, not "__SelectAll__"

I have a dynamic M query parameter which holds a list of IDs that are then passed to a query (specifically, a Kusto function that will return the desired table rows). Everything works perfectly with multi-select, but I want to allow users to "Select all" since there are a lot of IDs, and it's often not reasonable to select them individually.

 

Altering my function to handle the "__SelectAll__" value and return data for all identifiers in the table works. However, I have additional slicers in my report that filter the available values for the ID slicer; if users "Select all," the value of the parameter just becomes "__SelectAll__" instead of a list of IDs, so the query will return results for all IDs instead of only the IDs selected in the slicer.

 

So, my question is: How can I make "Select All" act like multi-select for a dynamic M query parameter, sending a list of all of the selected values instead of the string "__SelectAll__"?

 

To be clear, this is what I'm referring to:

I want the "Select all value" to just be a list of all the selected values, since the values available in the slicer change based on other user selections. 

4 Replies

  • TheoC's avatar
    TheoC
    Icon for Community Champion rankCommunity Champion

    Hi Anonymous 

     

    Can you group the ids in Power Query to the relevant lists you'd want each ID to be part of to create first slicer (Slicer 1) and then run a secondary slicer Slicer 2) that allows users to select individual ids that are part of respective groups forming part of Slicer 1?

     

    Effectively Users would use Slicer 1 to Select All IDs forming part of a Group and then use Slicer 2 to select the individual (or more) IDs forming part of the group?

     

    Hope I understood what you're after.

     

    Cheers, 

    Theo

  • hs28's avatar
    hs28
    Icon for Advocate I rankAdvocate I

    I am running into the same issue. Were you able to find any solution?