Smartfilter by SQLBI

[GaryK]

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%'

[v-haibl-msft]

@GaryK

As BhaveshPatel said, you should report this idea to support@okviz.com. As far as I know, the default slicer in Power BI Desktop also has the same behavior.

Best Regards,

Herbert

[v-sheset]

@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

[BhaveshPatel · Accepted solution]

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.