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.
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?
Solved! Go to Solution.
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.
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.
I bassicly want it to do this:
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
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,
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
116 | |
102 | |
78 | |
76 | |
49 |
User | Count |
---|---|
145 | |
108 | |
107 | |
89 | |
61 |