Chris Webb provides advice about a relatively new feature:
In the blog post for the October 2022 release of Power BI Desktop there’s a brief description of a new optimisation in Power BI for filters that perform searches in text columns. In this blog post I’m going to share more details about this optimisation and how you can make sure your reports can benefit from it.
Read on to learn a bit more about how it works, as well as a few tips on ensuring that you’re able to take full advantage of this optimization.