Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hello All
Is there a way in Power BI to determine what text a user has entered into a Text Filter search box? I've looked within the forums and I cannot find anything.
regards
Paul
I'm assuming you want to retrieve this in order to display it on a report - is this correct?
If this is the case there is no way to access this information directly, but one possible work around would be to use a custom text slicer on your page instead. See here for different options related to text filtering https://exceleratorbi.com.au/text-filtering-power-bi/ (specifically the last section on using custom visuals)
You can't really do anything like that directly.
On possible work around might be to create a concatenated column of the multiple fields you want to search
eg
AllNames = People[FirstName] & "|" & People[LastName] & "|" & People[NickName]
Then you could use a text filter over this column. The only downside is that you will more than double the storeage required for those columns, but if your table is not too big it might be a reasonable trade off. Note that I am using a vertical pipe character to delimit the different fields to prevent false positive matches (so if you have someone called "Bo Blue" they won't match a search for "Bob" as the AllName column stores them as "Bo|Blue" not "BoBlue")
Hi thanks for the quick reply.
It was not to display in the report, but to use it to search multiple columns using a single Text Filter. I was following the article How to filter on Multiple Columns . I've found that this works for certain data-sets but not my data-set as there are limitations to it. I think I could get it to work with my data-set if I could determine exactly what the user entered in the Text Filter. However it looks like at the moment that this is not possible within power BI.
regards
PaulDS
User | Count |
---|---|
125 | |
106 | |
99 | |
63 | |
62 |
User | Count |
---|---|
135 | |
116 | |
101 | |
71 | |
61 |