Multiple DirectQuery and Filters

[iqb]

I have around 40 DirectQuery SQLs like,

SELECT Col1, Col2 FROM Table1;



SELECT Col1, Col2 FROM Table2;



SELECT Col1, Col2 FROM Table3;

................................................................

................................................................



SELECT Col1, Col2 FROM Table40;

All table have some common columns like Col1 and Col2 above.

Now I added Slicer visual filter from Table1 but I wanna to apply filter to all 40 visuals(line-chart, pie-chart, etc) which uses different direct queries. How can I do this? The 40 visuals I have, actually in a dashboard.

[amitchandak · Accepted solution]

@iqb , check

https://learn.microsoft.com/en-us/power-bi/connect-data/desktop-dynamic-m-query-parameters

https://www.youtube.com/watch?v=L-wqwzj0-Xo

https://blog.crossjoin.co.uk/2020/10/25/why-im-excited-about-dynamic-m-parameters-in-power-bi/