Forum Discussion
Search Filter pane by Filter Value
Hello everyone! I know we can use the search bar in the Filters' pane to find a filter by its name. I am wondering if it is possible to search also by filter value in the Filters pane. To set an example suppose I have a filter called Order Category; the values of this filter can be Eshop, Physical store or Triangular and another one called Type of Client that can take the values Eshop, Physical, and Both. I wish to be able to type Eshop in the filters pane search bar and retrieve all the filters that include this value. Do you maybe know if this is possible or if there is a workaround to achieve it?
ps: An " it's not possible" answer would also help my case. I just need to know whether I can I achieve it.
Hi, Anonymous
According to your description, there is no way to search for multiple filters that have this value by entering a value. You can only search for a slicer individually to see if it has the value you want to search for.
As an example, like you want to enter text to confirm if this filter has Eshop, you can try the following method.
Measure = IF(SELECTEDVALUE('Table 1'[Order Category])="Eshop",1,0)Best Regards,
Community Support Team _Charlotte
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
3 Replies
Anonymous , Not very clear to me. See if a text filter can help
https://appsource.microsoft.com/en-us/product/power-bi-visuals/WA104381309?src=office&tab=Overview
Text Filter Slicer and how to search on Multiple columns: https://youtu.be/RbeZRJ3uAZE
amitchandak maybe I try to explain better.
Say for example i type XYW in the Filters pane search bar.
I would like to get as a result not the filters that contain XYW in their names but rather the filters that contain XYW in their values. Did I make it any more clear?Hi, Anonymous
According to your description, there is no way to search for multiple filters that have this value by entering a value. You can only search for a slicer individually to see if it has the value you want to search for.
As an example, like you want to enter text to confirm if this filter has Eshop, you can try the following method.
Measure = IF(SELECTEDVALUE('Table 1'[Order Category])="Eshop",1,0)Best Regards,
Community Support Team _Charlotte
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
