Forum Discussion
Searching for multiple values in Power BI
Hi!
I am looking for an option to search for multiple values in a slicer in Power BI. For example, let's say my database consists of all the worlds countries and their capitols. This is visualized in a big table. I then get a request to pull out a list of the capitols of Germany, US, UK and Spain. I like to copy in these four values in a search box and filter out the table to only display these four countries and their capitol.
Above is a simplified example, in reality I am working with a large database of values where the users might need to retrieve values on 100 customer numbers. In Excel it is easy to do since you can just do a VLOOKUP for the columns you need and copy in several rows of customer numbers.
Any ideas? I have tried searching but not found anything. Thanks in advance.
Hi Anonymous
In report layer, you can use a built-in visual Slicer, or custom visuals like Smart Filter to filter the data displayed. You can also use Filter pane to add filters in reports. All of them support searching and selecting multiple values to filter reports.
For example, if you use a slicer, you can show a Search box on it and turn off Single select.
Regards,
Community Support Team _ Jing
If this post helps, please Accept it as the solution to help other members find it.
2 Replies
Hi Anonymous
In report layer, you can use a built-in visual Slicer, or custom visuals like Smart Filter to filter the data displayed. You can also use Filter pane to add filters in reports. All of them support searching and selecting multiple values to filter reports.
For example, if you use a slicer, you can show a Search box on it and turn off Single select.
Regards,
Community Support Team _ Jing
If this post helps, please Accept it as the solution to help other members find it.