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

[apohl1]

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! 😊

[v-ssriganesh]

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.

[MasonMA · Accepted solution]

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~

[apohl1]

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.

[apohl1]

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..

[FBergamaschi]

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