Forum Discussion
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 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
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
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.
3 Replies
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
Brillaint thank you so much, this has helped a lot.
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.
