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

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
DvdH
Helper V
Helper V

Text filter based on multiple user inputted strings

Hey,
Im currently trying to do something.
It has to be user friendly and available as a visual in the report.
I am trying to choose multiple user inputted values as a filter/slicer.
i.e
Table: Test
Table rows:
A, 1, Yes
B, 2, No
C, 3, No
Columns: Letters, ID, Vowel
Column rows:
A
B
C all the way to Z
User text input(Sepperated by spaces only): A C
Preferred outcome.
A, 1, Yes
C, 3, no
I have tried a concetenated list, A Countrows filter with selectedvalue. I have no clue how to get this to work. Any support?

1 ACCEPTED SOLUTION
DvdH
Helper V
Helper V

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

4 REPLIES 4
DvdH
Helper V
Helper V

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.

DvdH
Helper V
Helper V

I bassicly want it to do this:

DvdH_1-1669291425710.png

It now only shows rows with one of those 4 order numbers. Crossed out for privacy reasons.
I want to do this with a text slicer instead.
So i can copy paste values into it(The values i'd input would be formatted as such:

80200000

92227111

63337511

13337323

daXtreme
Solution Sage
Solution Sage

Power BI does not take any user input, not to mention "sepparated by spaces only". All selections are done via clicking on values that are placed in visuals and which must reside in some base tables of the model.

 

I'd kindly suggest that before you try to do something... you learn a bit about the basics of Power BI. There are plenty of entry-level materials on YT. Please make use of this.

I am indeed very new, I might of said it the wrong way, 

DvdH_0-1669284488161.png

I ment inputted into the report instead of into somewhere such as filters. It has to be easily accesible for anyone. Im making this for someone and they will have full access to the data used. However they do not know how to work with Power BI so this has to be easily understood.
I have watched hours of entry-level information and know the basics. Just my formulation of the question could use work.


Bassicly there is an external data point not included into power bi where someone wants to copy paste a list of id's into my filter to get only those rows of data.
The id's are pasted like this:

10073211

23407743

12377966

Do u think that is possible?


Edit: I can not use Power APPS for this. Due to restrictions on the users pc.

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

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

April Fabric Community Update

Fabric Community Update - April 2024

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