Passing a user selected value in a slicer to the URL parameter

[sobaig]

Hi,

Currently I am working on a report where I want a user to be able to select a value in a dropdown slicer such that when the user selects a value, the value gets passed to the parameter URL. 

For example, 

Let's say there is a dropdown slicer for customer ID. The user selects customer ID 2 in the dropdown slicer. Once that happens, I want the URL to look like this:

...{ReportURL}?filter=[TableName]/CustomerID eq '2'

How can I do this? I tried following this resource: https://medium.com/microsoft-power-bi/parameterized-power-bi-navigation-practical-examples-for-using..., but I'm not sure if that is actually showing what I want to do. 

Thanks!

[Anonymous · Accepted solution]

Thanks for the valuable input from MFelix.

Hi @sobaig ,

I will add some details so that the requirements are better realized. Here are the exact steps of my implementation:

1.Here is the example data:

Note that the CustomerID here is of text type.

2.Create a measure:

If the part of the URL marked in yellow is present in the image, please remove it:

3.Create a slicer:

4.Insert a button, I use the blank type:

5.Open Action and select Web URL:

6.Set conditional formatting:

At this point, when you click this button you can open the report with CustomerID equal to 1

Best Regards,
Zhu

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

[MFelix]

Hi @sobaig  

For this you need to create your DAX measure with the full URL and only add the filter parameter at the end something similar to this:

URL link =
VAR _SelectCustomerID = SELECTEDVALUE(Table[CustomerID])
Return
IF(HASONEVALUE(Table[CustomerID])
"YOUR URL HERE ...{ReportURL}?filter=[TableName]/CustomerID eq '" & _SelectedCustomerID "'")