Forum Discussion
Creating a variable for 2 tables in advanced editor view
All,
I have this one table ProjectDetails , I am importing all projects since I left it blank. This is connected to "Project" tab which has visuals and a slicer
I have this other table Samples, where I used a fixed number for project because this has too many rows and it will time out if I leave blank. This is connected to "Samples" tab which has some visuals and a slicer.
My goal is to search a project from table 1 slicer and this project should insert into "Samples" and filter it to show all the visuals accordingly. Is this possible?
1 Reply
Hi aishak12 ,
Does the Samples table support connections using DirectQuery?
If so, then consider using dynamic M parameters to do this.
Dynamic M query parameters in Power BI Desktop - Power BI | Microsoft Learn
Currently, there are no more ways to use the slicer incoming parameters. You can submit ideas to help make Power BI better.
Welcome to Microsoft Fabric IdeasBest Regards,
Gao
Community Support TeamIf there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!How to get your questions answered quickly -- How to provide sample data in the Power BI Forum -- China Power BI User Group
