Forum Discussion

prabin09's avatar
prabin09
Frequent Visitor
2 years ago

Searching for multiple values for the same column using a text search in power bi

Hello Everyone, 
I am a beginner to Power BI. I was trying to create dashboards for one of my projects. I have imported a text search filter in Power BI from its marketplace. Using that filter, I can search for values in a column, but it only allows to searh for one value at a time. Let's say if I have a skill column and I am looking for Java and Python, then I cannot look for both the skills at a time. Is there any workaround to that so that I can search for Java + Python?

I know I can achieve something like this using a combination of dropdown plus text search. But the problem with that is my data is not standardized and it is difficult to standardize at this moment. I have 900+ thousand rows for the skills and have so many variations of skills like Java, Core Java, Basics of Java, Java Programming, Python, Python Basics, and so on. My users feel that its a tedious process to select/checkmark each variation of Java or Python skill using a drop down. This is the main problem I am trying to fix. I know the text search performs "contains" matching so that if I just type in Java then it can catch all the values that have %Java% in it. Again the problem to text search filter is it only allows 1 value to be searched at a time. 

If you have any ideas or suggestions, that would be helpful. Thank you in advance!
 

General Comment
Need Help
Show and Tell
Tips and Tricks
Tutorial Requests

4 Replies

  • lbendlin's avatar
    lbendlin
    Super User
    2 years ago

    using the filter pane you can search for up to two terms in the  same column.

     

    • prabin09's avatar
      prabin09
      Frequent Visitor
      2 years ago

      Hello lbendlin ,
      Thank you for your reply. I didn't quite understand your solution. Should I apply the advanced filtering on the text search filter or the dropdown slicer? Will my end-users have to edit advanced filtering everytime they are trying to look for values? 

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Hi prabin09 

    You can use the custom visual:text filter from app source

    Then you can put the field to the text filter visual

    Output

     

    Best Regards!

    Yolo Zhu

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

     

     

     

     

    • prabin09's avatar
      prabin09
      Frequent Visitor
      2 years ago

      Hello Anonymous,

      Thank you for your reply. I already have this setup. Now, what I am looking for is to be able to search for java and python at the same time in the search box. Something like Java, Python and it would show all the values at the same time like you have above.