slicer Selected value as sql query parameter

[PARIS2020]

I want to get the selectedvalue (table.id) and use it in my request as a parameter. for at each click on a row of the table, the query is executed with the selected value table[id].

I tried that : Parameter = selectedvalue(table[id]) , but failed

How can we do that ?

[amitchandak]

@PARIS2020 , refer

https://www.biinsight.com/power-bi-desktop-query-parameters-part-1/

https://radacad.com/change-the-source-of-power-bi-datasets-dynamically-using-power-query-parameters

https://community.powerbi.com/t5/Desktop/parameterize-connection/m-p/205900#M90712

[Anonymous]

HI @PARIS2020 

Can you please provide more info with screenshots, input and required output in table format for the community so that you ask can be better understood and resolved quickly.

[PARIS2020]

I have 2 tables :

     - a header table Ticket(IdTicket, summarize, Creation-Date, IdStatus)
     - detailed table Status (IdStatus, oldStatus, New status, IdTicket)

I need to find records on the Stauts table based on the IdTicket selected.

The IdTicket, appears in a report filter, and when I click on the IdTicket that interests me to select it. Once selected, this filter acts on the Status table to display only the records corresponding to the IdTicket selected.

My problem is that this operation requires retrieving more than 2 million lines, and it does not work well. I would like to be able to click on my IdTicket filter, and the selected value will be passed as parameter of a query that only fetch the values ​​that interest me.

[daniel__]

did you manage to find a solution to this ?