topic Re: Can I set the value of a parameter based on a slicer value in DAX Commands and Tips

Can I set the value of a parameter based on a slicer value

EaglesTony — Tue, 04 Apr 2023 18:30:20 GMT

I have a slicer and I can get the value showing on a card, but I also have a parameter I created within Power Query that is now showing on my fields tab.

I want to set this parameters value based off the slicer value, but don't know the syntax to do this, as this value will be a URL that will be used for the Data Refresh.

Re: Can I set the value of a parameter based on a slicer value

FreemanZ — Tue, 04 Apr 2023 23:06:07 GMT

hi EaglesTony

https://learn.microsoft.com/en-us/power-bi/connect-data/desktop-dynamic-m-query-parameters

Re: Can I set the value of a parameter based on a slicer value

EaglesTony — Wed, 05 Apr 2023 11:16:30 GMT

Hi are you saying to bind my parameter using this method ?...In my example, I have TableA with FieldQtr(this is bound to the slicer and contains Q1, Q2, Q3, etc) and FieldURL(This I want to use for my datasource).

When the user selects Q3 for example, I want then to take the corresponding FieldURL and populate my parameter with this value.

One thing to note, is that on the PowerBI Query side (via Transform data), I am creating the parameter there with URL values, then taking that parameter and use that as my "Source" for the data.

Re: Can I set the value of a parameter based on a slicer value

EaglesTony — Wed, 05 Apr 2023 12:38:24 GMT

Also, I am using Power BI July 2022 Update and based on this video dont see "Bind to Parameter" option, nor do I see under Global options "Dynamic M parameters".

Re: Can I set the value of a parameter based on a slicer value

EaglesTony — Thu, 06 Apr 2023 12:26:47 GMT

Unfortuantely, I don't see the option to turn on Dynamic query as the checkbox is not there in the options.

Re: Can I set the value of a parameter based on a slicer value

FreemanZ — Thu, 06 Apr 2023 14:31:38 GMT

hi EaglesTony

Sorry, just learned this feature is applicable for Direct Query only.

for further information, you may check:

https://learn.microsoft.com/en-us/power-bi/connect-data/desktop-dynamic-m-query-parameters

https://community.powerbi.com/t5/Desktop/Power-BI-Dynamic-M-Query-Parameter-binding-not-shown/td-p/1457915

https://community.powerbi.com/t5/Desktop/Bind-to-Parameter-Not-Showing/m-p/2202608

Re: Can I set the value of a parameter based on a slicer value

EaglesTony — Thu, 06 Apr 2023 14:34:43 GMT

Thanks. When they say Direct Query, what does that mean ?

I am using a JIRA Data connector as my source.

Re: Can I set the value of a parameter based on a slicer value

NikNithiy — Wed, 02 Aug 2023 18:56:47 GMT

It is only when you connect with direct query as you data source. Did you find ou any solution?