How to do multiple texts filters in text slicer in POWERBI Report

Question

Hi,

I am trying to use a User input based TEXT Filtering on the page in a Power Bi Report. It is working fine when I give single value. But how to achieve the end result for multiple values .

Eg : Poland and Portugal on Country filter

Answer

Hi Pradeep1 S,

Thank you for reaching out to us on Microsoft Q&A forum.

. To filter multiple values, such as "Poland" and "Portugal," in a Power BI report using a slicer, please follow these steps:

Multi-Select in Slicer:
- Use the built-in slicer visual to filter by multiple values. Once the slicer is added to your report with the Country field, you can enable multi-selection by holding down the Ctrl key (or Shift key) while selecting the desired countries, such as "Poland" and "Portugal." This will allow you to filter the data based on both countries simultaneously.
Search and Select:
- Alternatively, if the slicer has many values, you can use the search functionality to quickly find and select "Poland" and "Portugal" for filtering.

We tested on our end, and everything is working fine. Kindly refer to the screenshot below for reference. User's image If you are still facing any issue, please let us know in the comments and where you are encountering this error along with the screenshot for reference. We are glad to help you.

Please don’t forget to Accept Answer and Yes for "was this answer helpful" wherever the information provided helps you, this can be beneficial to other community members.

Thank you.

Share via

How to do multiple texts filters in text slicer in POWERBI Report

1 answer

Your answer