Parameter - How can I change

[Anonymous]

DataBase Code URL: 

let
Fonte = Web.BrowserContents("http://sbripvs0022/CronetJVX//pido/getReport?p_pido=50000000681&p_table=50000000300&SHIFT_DATE2=" & Data2 & "000000&SHIFT_DATE1=" & Data1 & "000000&p_crosscompany=0&p_format=HTML&p_pagination=0&p_showtitle=0&p_showselection=0&p_paperformat=A4&p_userid=TVEN/tven@cronet_cpbritu1"),
#"Tabela extraída de HTML" = Html.Table(Fonte, {{"Column1", "TABLE.jrPage > * > TR > :nth-child(1)"}, {"Column2", "TABLE.jrPage > * > TR > :nth-child(2)"}, {"Column3", "TABLE.jrPage > * > TR > :nth-child(3)"}}, [RowSelector="TABLE.jrPage > * > TR"]),
#"Tipo Alterado" = Table.TransformColumnTypes(#"Tabela extraída de HTML",{{"Column1", type text}, {"Column2", type text}, {"Column3", type text}})
in
#"Tipo Alterado"

I Have 2 parameter for change de Data1 and Date2:

"10082020" meta [IsParameterQuery=true, List={"VAR_data2"}, DefaultValue=..., Type="Text", IsParameterQueryRequired=true]

and

"13082020" meta [IsParameterQuery=true, List={"VAR_data1"}, DefaultValue=..., Type="Text", IsParameterQueryRequired=true]

How can I change parameter text using a filter ? I need update those parameter in Power BI (site) too, is this possible ? without click in edit parameter.

[v-zhenbw-msft · Accepted solution]

Hi @Anonymous ,

Sorry for that you cannot use a slicer or filter to change the parameter.

You need to click the edit parameter to change it.

Please refer the following articles.

https://powerbi.microsoft.com/en-us/blog/deep-dive-into-query-parameters-and-power-bi-templates/

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

Perhaps you can submit the requirement to ideas and add your comments there to make this feature coming sooner : https://ideas.powerbi.com/forums/265200-power-bi-ideas

Best regards,

Community Support Team _ zhenbw

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.