Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Get certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now

Reply
Anonymous
Not applicable

Filter dataset based on multiple inputs(Strings).

Hey! I am decently new to Power BI and I'm requesting your support!
So im trying to filter out data from my table. In particular the column Order.
What i am trying to achieve is:

DvdH_1-1669291889990.png

A filter working exactly like this does. However i want to be able to copy paste the filter value myself. i.e

12345678

87654321

24356871
I want to be able to copy paste that into

DvdH_2-1669291989427.png

Custom text filter^.

Would there be a way to input multiple values at once?
I want the exact same outcome as the first picture but with text instead of selecting the order numbers. Because i might need to filter based on 100 order numbers and it would not be handy to do this manually.
This should be such a simple visualization but i just can't quite put my finger on it.
Any suggestions are welcome! I've looked at somany possible things to do...

 

 

 

 

1 ACCEPTED SOLUTION
Anonymous
Not applicable

Hey! I've found the solution i needed for this problem after 2h+ of googling and tweaking.
Video: Power Bi - Filter by Multiple Comma Separated Values - YouTube
It is a visual called Mass filter that does exactly what i needed.
Need help installing/using it? Check out the amazing video as seen above.

View solution in original post

7 REPLIES 7
Anonymous
Not applicable

Hey! I've found the solution i needed for this problem after 2h+ of googling and tweaking.
Video: Power Bi - Filter by Multiple Comma Separated Values - YouTube
It is a visual called Mass filter that does exactly what i needed.
Need help installing/using it? Check out the amazing video as seen above.

NikhilChenna
Continued Contributor
Continued Contributor

Hi @Anonymous , I hope this solution will help you. 

 

I have tried the Smart Filter Pro and I don't think it supports copy pasting multiple values.
You will have to type in multiple values and select one at a time.

This is also available in the default slicer visual, where you can type in one value at a time and do the selection.
You will need to turn off the 'Single Selection' and turn on the 'Multi-Selection with Ctrl' from the formatting pane of the visual.

However, if this does not work for you and if you want a substitute to the Smart Filter Pro, then you can have a look at the 'Attribute Slicer'​ custom visual.
It is made by Microsoft itself, so I doubt there should be any problems in getting it approved from the admin.

Here is a video for the attribute slicer:
https://www.youtube.com/watch?v=hamLu0tYSRo

Please let us know if this works for you and if not, kindly share your solution once you resolve the problem.

 

Regards,

Nikhil Chenna

 

Appreciate with a Kudos!! (Click the Thumbs Up Button)
Did I answer your question? Mark my post as a solution!

Anonymous
Not applicable

The Smart Filter Pro Copy & Paste is exactly what i was looking for... However this is a paid subscription and as such i won't be able to use it. However i can use it as an example for people to understand what i need. So thanks anyways! I used the demo and it worked how i'd need to use it.

Hi @Anonymous ,

 

As the solution is working for you. 

 

Appreciate with a Kudos!! (Click the Thumbs Up Button)
Did I answer your question? Mark my post as a solution!

Anonymous
Not applicable

Hey sadly the solution does not work since it is a paid subscription based visual. However i have found the solution and will comment about this and accept it.

Anonymous
Not applicable

Indeed the selecting multiple values was found by me aswell. I will have a look at the smart filter pro however it is a must to copy paste all values. Since like i said i could be working with 100s of filter values. I can't type them all if i did that im better off using the normal Slicer already equipped in Power BI since u can then select all values aswell. I will take a look at smart filter pro. Thanks in advance!

@Anonymous ,

 

Appreciate with a Kudos!! (Click the Thumbs Up Button)
Did I answer your question? Mark my post as a solution!

Helpful resources

Announcements
November Carousel

Fabric Community Update - November 2024

Find out what's new and trending in the Fabric Community.

Live Sessions with Fabric DB

Be one of the first to start using Fabric Databases

Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.

Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.

Nov PBI Update Carousel

Power BI Monthly Update - November 2024

Check out the November 2024 Power BI update to learn about new features.