Forum Discussion
Filter By List By DevScope
I am using the "Filter By List" visualization to apply bulk filters. I would like to know what is the maximum number of values that can be listed in that filter? I have a requirement of applying 20,000+ values as filters. It is making the report extremely slow. If you know any other easiest and efficient method to apply such huge filters to the Power Bi report, please suggest.
2 Replies
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.