Forum Discussion
Search box - Using 1 column from three queires ?
- 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
- Anonymous1 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.
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.