Forum Discussion
Smartfilter by SQLBI
Is there a way with Smartfilter (or alternative approach) where the list of results match from the start or the values instead of values the contain the search text?
Example,
Let's say that the dataset is as follows:
Apples
Oranges
Pears
GrapeFruit
Strawberry
Plums
When I type "A" for apple, I want to only see the values that start with "A", but instead the list contains all values exept for Plums
When I then type "AP", the list contains APples and grAPefruit.
The behaviour suggests that the search is based on LIKE '%AP%', whereas I would prefer it to be LIKE 'AP%'
Hi GaryK
You can say that there is a bug and you can report it to sqlbi.com to improve the search behaviour like Intellisense.
Meanwhile, You can create a other regular slicer and select the A category to cross filter SmartFilter Values by A category.
Create the other column based on the First Letter and use as a regular slicer.
3 Replies
- BhaveshPatel
Super User
Hi GaryK
You can say that there is a bug and you can report it to sqlbi.com to improve the search behaviour like Intellisense.
Meanwhile, You can create a other regular slicer and select the A category to cross filter SmartFilter Values by A category.
Create the other column based on the First Letter and use as a regular slicer.
v-haibl-msftMicrosoft Employee
As BhaveshPatel said, you should report this idea to [email protected]. As far as I know, the default slicer in Power BI Desktop also has the same behavior.
Best Regards,
Herbert
v-haibl-msft What is the filter you pointed to called. I am unable to find it instore or as default filters in the visualizations availble in power bi. I am looking for a filter where I can search as well as use the boxes to select what I need
