Forum Discussion

GaryK's avatar
GaryK
Frequent Visitor
9 years ago
Solved

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 ...
Need Help
  • BhaveshPatel's avatar
    BhaveshPatel
    9 years ago

    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-msft's avatar
v-haibl-msft
Icon for Microsoft Employee rankMicrosoft Employee
9 years ago

GaryK

 

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-sheset's avatar
    v-sheset
    Frequent Visitor
    8 years ago

    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