If your 3 data sources can be mapped with couple of keys and blended well, the filter could apply to your dashboard. but things may become complicated when you use LOD, please refer to Filters and Level of Detail Expressions for more details.
my personal experience is if you could join your data in advance, it will give you better performance rather than data blend afterward. Just imagine, when the data source become bigger and bigger, every time when your dashboard refreshing, it will go back to load the data and do the blending again and again.
Hope this could help.
Zhang, Thank you very much For your Reply.
However here I have a small doubt, Could you please Explain that.
In My SQL Data source I have 1 table, In that Table, i have 10 columns, Column A,B,C,D,E,F,G,H,I,J,
In SQL Data Source I have One more Table, That Table contains 4 Columns B, C, K, L.
I have onther data source EXCEL In that 3 Columns are their F, G, M.
Based On All data I created 9 worksheets. Based On 1st data source I created 5 worksheets, Based on 2nd data source created 2 worksheets (Graphs) and 3rd Data source Excel Based on that I created 2 worksheets. Total 9 worksheets i placed in one Dashboard.In Dashboard I Placed Filters as A,B,C,D,E,F,G,H,I,J. So here if click A Filter i need to see data changes in all 9 worksheets.How we can do this Task Please Explain me Step by Step.
I think in your case, the best way is to use parameter and create calculation fields related to this parameter in each data source so that the data would be refreshed once the parameter changes across all the data sources. Hope this could help