Get the value in Power Query from Slicer Selection

[Anonymous]

Hello All,

I am integrated on slicer to get the month's date.... its is dynamically to follow this link : https://www.powerquery.training/portfolio/dynamic-calendar-table/

I want to Slicer selected value parse to my power query link :
let
    StartDate="Selected Vaule from Slicer",

------So i can use this value to my query.--------
in
    StartDate

Please let me know if you guys have any solution about this senario...

Thanks in advance.

Pankil

[v-huizhn-msft · Accepted solution]

Hi @Anonymous,

Based on what I know, we can't get the selected value from slicer in Query Editor. I suggest you can use parameter. Please use the slicer column to create a list in Query Editor, and add the parameter as start date as follows.

= List.Dates(Parameter1,100, #duration(1,0,0,0))

In Power BI desktop, please click the Edit Queries->Edit parameter, you will select different value in parameter list, the table start date will change after you click "Apply changes"

step1
step2
result
Reference: POWER BI DESKTOP QUERY PARAMETERS, PART 1

Best Regards,
Angelia