Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi all,
Say I am displaying this table in Power BI.
Name | Phone |
John Doe | 111-111-1111 |
Jane Done | 222-222-2222 |
Smith John | 333-333-3333 |
Is it possible to provide a search box for the name field that let users to type in string such as "John" and the table will return with the lines of "John Doe" and "Smith John"? How can it be done?
Thanks.
dc7669
Solved! Go to Solution.
Hello @dc7669 ,
You can do this using slicer, click the 3 points, and click Search.
Did I answer your question? Mark my position as a solution!
Ricardo
Hello @dc7669 ,
You can do this using slicer, click the 3 points, and click Search.
Did I answer your question? Mark my position as a solution!
Ricardo
Hello @dc7669 ,
You can do this using slicer, click the 3 points, and click Search. After you select them, the table will be filtered.
Did I answer your question? Mark my position as a solution!
Ricardo
For your selector, you would use the SEARCH or FIND functions.
@Greg_Deckler I think your solution probably will work. But, I am not too familiar with "Measure", thinking that is more related to time/geography based hierarchy. @camargos88 solution is easier for me to understand. Thanks for sharing!
Here is another example attached.
Yes, you would want what I refer to as a complex selector. I will attach examples. Basically, it is a measure that returns 1 or 0 based upon whatever condition you specify. It is based on Inverse Selector.
https://community.powerbi.com/t5/Quick-Measures-Gallery/Inverse-Selector/m-p/648290#M325
Attached complex selector examples.
User | Count |
---|---|
103 | |
90 | |
78 | |
72 | |
68 |
User | Count |
---|---|
108 | |
96 | |
95 | |
74 | |
71 |