Forum Discussion
desktop, advance search filtering multiple items
Hello, Im using desktop. I need to select multiple items more than 4 but basic filtering unable to obtain list because dataset is huge. Advanced filtering allow to use only two value. Is any other ways to resolve that?
Greatly appreciate any help!
Hi Anonymous ,
If you need to filter by more than two values, you can use the "Filter by List" option. This option allows you to filter by multiple values, but it can be slow if your dataset is large. Another option is to use the Expression . This option allows you to filter by multiple values and is faster than the "Filter by List" option.
How to Get Your Question Answered Quickly
If it does not help, please provide more details with your desired output and pbix file without privacy information (or some sample data) .
Best Regards
Community Support Team _ RongtieIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
3 Replies
Anonymous are you using DQ?
👉 Learn Power BI and Fabric - subscribe to our YT channel - @PowerBIHowTo
If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤️
Hi parry2k,
Appreciate your answer! Im new in powerbi desktop. We use life connnection to huge (8 mln+) dataset and basic filtering can't display all items of the column. i need to select 4 items but advanced filtering has option only for two. If you can send me a link what solution can resolve this issue? I went through names of your videos but couldn't find any related, thanks a lot
Hi Anonymous ,
If you need to filter by more than two values, you can use the "Filter by List" option. This option allows you to filter by multiple values, but it can be slow if your dataset is large. Another option is to use the Expression . This option allows you to filter by multiple values and is faster than the "Filter by List" option.
How to Get Your Question Answered Quickly
If it does not help, please provide more details with your desired output and pbix file without privacy information (or some sample data) .
Best Regards
Community Support Team _ RongtieIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
