Custom visual text filter using columns from multiple tables?

[Anonymous]

Hi,

I would like to ask that is it possible to somehow make a single text filter search values from colums outside same table. I've found a way to include many columns from same table to one text filter, but I'm facing problems adding colums from another table.

I'm wondering that is this even possible to do?

[v-luwang-msft]

Hi @Anonymous ,

Pls refer the following article and check if it could solve your question:

https://community.powerbi.com/t5/Desktop/Text-Filter-for-Multiple-Tables/m-p/869999 

And if question still not solved ,could you pls share a sample data,and expected output result.

Best Regards

Lucien

[amitchandak]

@Anonymous , refer if my video can help

Text Filter Slicer and how to search on Multiple columns: https://youtu.be/RbeZRJ3uAZE

[Anonymous]

@amitchandak First of all thank you for your response. I have managed to get a similar solution as you have on the video you linked.

I'm wondering that is it possible to concatenate the two calculated columns named "Seach column" together inside only one table? For example concatenating the column named "Seach column" with the column you made to Item table. Therefore it would be possible to seach Item data and Geographical data with just one text filter if it's somehow doable.

Thank you for taking your time and trying to help me with the question.