Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
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!
Solved! Go to 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.
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.
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 "'")
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsUser | Count |
---|---|
134 | |
72 | |
71 | |
55 | |
54 |
User | Count |
---|---|
201 | |
95 | |
63 | |
62 | |
51 |