Passing Query Parameter using selected slicer record

[lokeshpatel]

Hello,

I am building a report that includes querying a SQL database with a parameter. I can successfully pull the information if I select the parameter but would like to augment it so the user can select the Server/Date instead of the ID (parameter).

Server Table				Slicer		FactTable
Server	Date	ID		+Server 1		SQL
Server 1	Date 1	123		-Date 1		Select * From [TABLE]
Server 1	Date 2	124		-Date 2		Where ID = {Parameter}
Server 1	Date 3	125		-Date 3
Server 2	Date 4	126		+Server 2
Server 2	Date 5	127		-Date 4
		**Binded to Parameter**		-Date 5

The solution works if I select the specific ID on a table visual as a result of the slicer but does not work otherwise. How can I have the user select the Server/Date and the parameter to populate?

Thanks in advance.