Customizable Power BI slicer that enables searching within one or more text fields.
- Filtering hierarchy fields is not supported.
- Power BI native 'Clear all slicers' button not supported.
Feel free to create an issue with the problem description or contact us at info@databrothers.cz.
- Text search slicer is now available in the Power BI AppSource.
- After installing the visual and placing it in your canvas, add one or more text fields in the visual setup pane.
- The input field of the slicer should be now visible.
- Type any text in the input field and confirm it by pressing ENTER key or by clicking the search button.
- Case-insensitive contains filter is now applied. That means it searches for the input text in any part of the selected field and it ignores lower and upper cases.
- Filter also supports wildcard characters.
- A question mark (?) for any single character.
- An asterisk (*) for any sequence of characters.
- When searching for an actual question mark or asterisk, place a tilde (~) before the character.
- If any changes are made in the input field and they are not confirmed then the slicer fallbacks to its last state.
- After adding more than one text fields in the visual setup pane, additional buttons are displayed under the input field.
- If the button is highlighted it means that filter is going to be applied to the corresponding field.
- It is possible to change currently filtered field by clicking the corresponding button.
- If any search is already applied and the filtered field is changed then the new filter is applied immediately without confirming by ENTER key or the search button.
- The filter is removed after pressing the clear button or after confirming an empty search.
- General - customization for the entire visual. (font family, font size)
- Input field - customization for the input field. (color, padding, border, placeholder)
- Input field action - customization for the search and clear buttons. (color)
- Field selection - customization for the searched field switching buttons. (color, border, padding)
Do not forget to write a review in the Power BI AppSource.