topic Re: How to efficiently filter multiple values in a Power BI slicer without selecting each one manually? in DAX Commands and Tips

How to efficiently filter multiple values in a Power BI slicer without selecting each one manually?

apohl1 — Mon, 01 Sep 2025 12:11:11 GMT

Hi all,

Is there a user-friendly way for end-users of a Power BI report to filter for 30+ values in a slicer without having to select each one individually?

Thanks in advance! 😊

Re: How to efficiently filter multiple values in a Power BI slicer without selecting each one manually?

FBergamaschi — Mon, 01 Sep 2025 12:20:39 GMT

Hi apohl1

not as fare as i Know bout you can enable the text search if the values are text, and search on a smaller subset

But for selection, you need to do it manually (with CTRL for multi select)

At least that's all I know

If this helped, please consider giving kudos and mark as a solution

@me in replies or I'll lose your thread

Want to check your DAX skills? Answer my biweekly DAX challenges on the kubisco Linkedin page

Consider voting this Power BI idea

Francesco Bergamaschi

MBA, M.Eng, M.Econ, Professor of BI

Re: How to efficiently filter multiple values in a Power BI slicer without selecting each one manually?

apohl1 — Mon, 01 Sep 2025 14:03:00 GMT

Thanks! This way I'm aware of. Ideally if there would be a way to input several values in the search box but it doesn't seem to work..

Re: How to efficiently filter multiple values in a Power BI slicer without selecting each one manually?

MasonMA — Mon, 01 Sep 2025 20:29:31 GMT

Hello apohl1

Consider using 'Smart Filter Pro' by (OKViz), which allows copy/paste of multiple values.

Here's a video about its features, https://www.youtube.com/watch?v=lyjFSy9iRmo

Hope this helps~

Re: How to efficiently filter multiple values in a Power BI slicer without selecting each one manually?

v-ssriganesh — Wed, 03 Sep 2025 11:18:55 GMT

Hi apohl1,

Thank you for posting your query in the Microsoft Fabric Community Forum, and thanks to MasonMA for sharing valuable insights.

Could you please confirm if your query has been resolved by the provided solutions? This would be helpful for other members who may encounter similar issues.

Thank you for being part of the Microsoft Fabric Community.

Re: How to efficiently filter multiple values in a Power BI slicer without selecting each one manually?

apohl1 — Wed, 03 Sep 2025 12:01:01 GMT

Thank you. It seems like a great alternative but unfortunately it comes with a cost. I was looking for a free alternative. But I will accept the solution.