Filter By List By DevScope

Hi Anonymous ,

Based on the information you provided, as far as I know there is no specific limit to the number of values that can be listed in a filter. However, it looks like you have a lot of data to filter, and applying so many filters may cause performance issues.

Is the data you want to filter numeric or text?
You could try creating a new column containing the conditions to be filtered, using conditional filters is more efficient when working with large data.

Or you can use advanced filters in power query to filter, I recommend you to read this article:

Filter by values in a column - Power Query | Microsoft Learn

How to Get Your Question Answered Quickly - Microsoft Fabric Community

If it does not help, please provide more details with your desired out put and pbix file without privacy information.

^{Best Regards,}

^{Ada Wang}

^{If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.}