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 ...
Need Help
TheoC's avatar
TheoC
Icon for Community Champion rankCommunity Champion
4 years ago

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