Search box - Using 1 column from three queires ?

[Benc7777]

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 the below I have three queries all with the column Cref, I want to be able to search Cref in the search box and for it to filter the three visuals.

This is going to be used by a basic user so i didnt want anything complication and to make it as easy as possible for them.

Is this possible at all, I think it maybe something to do with Relationships but i dont really understand those as yet .

Any help greatly appriciated, it really would.

B

[shafiz_p · Accepted solution]

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 · Accepted solution]

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.

[shafiz_p · Accepted solution]

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

[Benc7777]

Brillaint thank you so much, this has helped a lot.