Forum Discussion
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
- lbendlin
Super User
If this is important to you please consider raising it at https://ideas.powerbi.com
- TheoC
Community 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
- RicoZhou2
Resolver I
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.
- hs28
Advocate I
I am running into the same issue. Were you able to find any solution?