Forum Discussion
Slicer Search Select all based on comments
- Anonymous1 year ago
Hi ZachUnger
Currently, the default slicer in Power BI cannot do this.
Once you start a search, the Select All option disappears and only the matching options are displayed.You can vote for an existing idea or submit a new one at Microsoft Fabric Ideas.
The following are two alternatives:
1. Using the method mentioned in Irwan's reply
First enable the Show "Select all" option in the slicer settings.
Do not enter content in the slicer's search box, in the slicer's visual filtering pane, "Filter Type" select "Advanced filtering", "Show items when the value" selects "contains", enter content here and "Apply filter".
This way the “Select all” option in the slicer visual will not disappear.
2. Click “Get More Visuals” to add Text search slicer visual
Enable the “Show ‘Select all’ option” in the Power BI default slicer.
Create the Text search slicer, add the required fields, and then enter the content to search.
Best Regards,
Jarvis Tang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi ZachUnger
Currently, the default slicer in Power BI cannot do this.
Once you start a search, the Select All option disappears and only the matching options are displayed.
You can vote for an existing idea or submit a new one at Microsoft Fabric Ideas.
The following are two alternatives:
1. Using the method mentioned in Irwan's reply
First enable the Show "Select all" option in the slicer settings.
Do not enter content in the slicer's search box, in the slicer's visual filtering pane, "Filter Type" select "Advanced filtering", "Show items when the value" selects "contains", enter content here and "Apply filter".
This way the “Select all” option in the slicer visual will not disappear.
2. Click “Get More Visuals” to add Text search slicer visual
Enable the “Show ‘Select all’ option” in the Power BI default slicer.
Create the Text search slicer, add the required fields, and then enter the content to search.
Best Regards,
Jarvis Tang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
- ZachUnger1 year agoHelper II
This worked perfectly! thank you!