slicer Selected value as sql query parameter

Question

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 ?

anonymous · Answer

HI&nbsp;PARIS2020&nbsp;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.

amitchandak · Answer

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

paris2020 · Answer

I have 2 tables : &nbsp;&nbsp;&nbsp;&nbsp; - a header table Ticket(IdTicket, summarize, Creation-Date, IdStatus)&nbsp;&nbsp;&nbsp;&nbsp; - 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. &nbsp;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__ · Answer

did you manage to find a solution to this ?&nbsp;

Forum Discussion

slicer Selected value as sql query parameter

4 Replies

Related content

Parameter selection for charts

Selected slicer

Slicer default selection

How to filter a slicer dynamically based on selection on field parameter

Single select slicer