Forum Discussion
Passing Query Parameter using selected slicer record
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.
No RepliesBe the first to reply