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

[Anonymous]

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. 

[hs28]

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

[RicoZhou2]

Hi @Anonymous ,

As far as I know, the Select all value is used to refer to the Select all option in the M Query. This value is passed to parameter as a list that contains the value you defined for select all. "__SelectAll__" will work as a list that contains all value in your list.

For reference:

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

Best Regards.

[TheoC]

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

[lbendlin]

If this is important to you please consider raising it at https://ideas.powerbi.com