Forum Discussion
Change data source dynamically using a Slicer by binding to parameter
I have two identical SQL Server DBs hosted in two different servers. I want to create a report so that I can switch between both the servers and see data accordingly. I have followed this video and m...
Hi itsMeKapz ,
Based on the current capabilities of Power BI and as of my latest knowledge, slicers and query parameters work on different levels, you can't use a front-end slicer to influence back-end query parameters.
Reference: Dynamically Change Data Source Using Parameter and... - Microsoft Fabric Community
However, you can refer to the method in the following link as a workaround.
Change the Source of Power BI Datasets Dynamically Using Power Query Parameters - RADACAD
Best Regards,
Yulia Yan
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.