Without sample .twbx file its hard to help you. Please send some mockup file to better understanding your requirements.
thak you for your answer
I can't use UNION because the tables are not the same structure. and the field's names are differents too.
Please share the data in that case.
Thanks for your answer
let me prepare an example, and I will attach it.
If the Date field and values are going to be same in all 3 data sources then you can create a calculated field to join (combine) all 3 and use that Calc as filter Date across your views. Something in the below line of thought:
if Date1 = Date2 and Date2 = Date3 then Date2 end
Good, For every problem, there are alternative solutions.
thanks for answering
the data field and values, are different in each table. for example,
table1 FieldName= "Date" = 01/01/2018
table2 FieldName= "End Date" = 15/01/2018
table3 FieldName= "Date3" = 28/01/2018
i want to join these 3 field like one. and show for this case this field like filter and show 01/2018
Please attach a sample workbook so that we can work out a solution. Thank you