Forum Discussion

Benc7777's avatar
Benc7777
Helper I
1 year ago
Solved

Search box - Using 1 column from three queires ?

Morning all,   I have done the below, but want a the search box (I have download a few but the microsoft looks ok) but it only allows me to search on 1 query.   So to explain my rambling ! On th...
  • shafiz_p's avatar
    1 year ago

    Hi Benc7777 

    For text filter, I have used Microsoft Text Filter. It depends on relationship, how you define and how you want to filter. Check my relationship:

    I have used EMPLOYEE_NO from EMPLOYEE table in text filter value field.
    Check out my result:

     

    Without filter:

    When want to search a specific no, Let's say, TC-002. Check out:

     

    So check out your relationship table and place the field from dimention table, which able to filter all table.

    Hope this helps!!

    If this solved your problem, please accept it as a solution and a kudos!!

     

     

    Best Regards,

    Shahariar Hafiz

  • Anonymous's avatar
    Anonymous
    1 year ago

    Your solutions is great shafiz_p 

    Hi, Benc7777 

    You can click on your slicer to install the following image operations:

    If you are using a separate table as a slicer, you may need to write a measure like this:

    Measure = 
    VAR _search_values = VALUES(SlicerTable[Product])
    RETURN IF(SELECTEDVALUE(financials[Product]) IN _search_values,1)

    Place it in the filter panel of the Product column visual object and set the value to 1:

     

     

     

    How to Get Your Question Answered Quickly

    If it does not help, please provide more details with your desired output and pbix file without privacy information (or some sample data) .

    Best Regards

    Jianpeng Li

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